| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a worksheet in a workbook
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 -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting used cells only in the workbook | Excel Discussion (Misc queries) | |||
| Selecting workbook | Excel Programming | |||
| Help!!!! Selecting a cell in another workbook | Excel Programming | |||
| selecting workbook/worksheet from browse button | Excel Programming | |||
| Selecting the other open workbook | Excel Programming | |||
![Lazer[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
