active worksheet

  • Thread starter Thread starter Matthew Dyer
  • Start date Start date
M

Matthew Dyer

Set wb2 = Workbooks("LESTER, BRENDA.xls")


how do I replace the above code to set wb2 as the active sheet?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Needed Macro and Function Help 4
Open a workbook using a stored name 3
activate workbook 1
re : Copying a range from WB01 and pasting to WB02 4
Last row in a particular sheet / workbook 4
disable a button 4
How to Run a Macro From WB1 in WB2 Against WB2 5
Simple Copy/Paste Question 5

Back
Top