Thread: Selecting a worksheet in a workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Selecting a worksheet in a workbook
is mainworkbook the activeworkbook.

mainworkbook.Activate
mainworkbook.Worksheets(wrksheet.Name).Activate

or

Application.Goto wrksheet.Range("A1"), true

--
Regards,
Tom Ogilvy


"Lazer " wrote in message
...
I have two workbooks. I want to select a worksheet by name.
"Wrksheet.Name" *is* evaulating to the name of the sheet - but on the
following line I get that it is not a proper method of Worksheets...

mainworkbook.Worksheets(wrksheet.Name).Select

Thanks!
Eliezer


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote