| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
specifying workbook for Sheet1
There was discussion last week of the advantage of referring to a worksheet
by Sheet1 rather than WorkSheets("mysheet") or WorkSheets(1). My question is how to specify what workbook the sheet is in. Nothing I've tried works. For example I've tried: Workbooks("mybook").Sheet1 Thanks in advance, Doug |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| [=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') | Excel Worksheet Functions | |||
| How do I set up a workbook so changing Sheet1 changes all sheets? | Excel Worksheet Functions | |||
| copy sheet1 from all open workbooks to one workbook | Excel Programming | |||
| How? Force Sheet1 to display each time the workbook is opened. | Excel Programming | |||
| Sheet1 object not Worksheets("Sheet1") | Excel Programming | |||
Threaded Mode
