Selecting a worksheet in a workbook

L

Lazer

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

mainworkbook.Worksheets(wrksheet.Name).Select

Thanks!
Elieze
 
T

Tom Ogilvy

is mainworkbook the activeworkbook.

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

or

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