| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referring to a Worksheet with a variable
This The expression works OK:-
Set VBComp = ThisWorkbook.VBProject.VBComponents("Sheet1") But what is the correct syntax if I want to refer to a sheet with a variable number? Suppose the variable sheet number is MySh, then ("SheetMySh") produces a runtime error "Script out of range" -- donwb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referring to a variable cell on another sheet | Excel Worksheet Functions | |||
| Referring to a variable file name | Excel Discussion (Misc queries) | |||
| Recall a variable referring to a worksheet name? | Excel Programming | |||
| Referring to a worksheet using variable | Excel Programming | |||
| Referring to a local or global variable or constant dynamically? | Excel Programming | |||
Threaded Mode
