active worksheet
in [Programming]
|
Prev: Select range from ActiveCell do to Lastcell in ColumnA
Next: Checking specific text string in excel files stored in a folder
From: Matthew Dyer on 15 Mar 2010 23:00 Set wb2 = Workbooks("LESTER, BRENDA.xls") how do I replace the above code to set wb2 as the active sheet?
From: paul.bellrichard on 15 Mar 2010 23:41 Try... Windows(wb2).Activate On Mar 15, 10:00 pm, Matthew Dyer <matthew.e.d...(a)gmail.com> wrote: > Set wb2 = Workbooks("LESTER, BRENDA.xls") > > how do I replace the above code to set wb2 as the active sheet?
From: Matthew Herbert on 15 Mar 2010 23:56
Matthew, Try the following: Dim Wks As Worksheet Set Wks = ActiveSheet (Note that if you don't specifically state the qualifing hierarchy, Excel will build the hierarchy for you. For example, "Set Wks = ActiveSheet" will be appended to be ActiveWorkbook.ActiveSheet, whereas something like "Set Wks = Workbooks("test.xlsx").Worksheets(2)" will reference a specific worksheet from a specific workbook, regardless of which workbook is currently active). Best, Matthew Herbert "Matthew Dyer" wrote: > Set wb2 = Workbooks("LESTER, BRENDA.xls") > > > how do I replace the above code to set wb2 as the active sheet? > . > |