View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal Robert Crandal is offline
external usenet poster
 
Posts: 309
Default Confused about sheets and "Select" vs "Activate"

Yes, that is correct. I have several workbooks open.

I thought that Workbooks("DataBook.xlsm") would specify
the correct workbook and therefore that either
Sheets(n).Activate OR Sheets(n).Select would do the same
thing????

"Gary Keramidas" <GKeramidasAtMSN.com wrote in message
...
i'm guessing you're trying to select a sheet in a non-active workbook. do
you have more than 1 workbook open?

--


Gary Keramidas
Excel 2003