Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to call an object by its codename with a variable, rather than by the
object group the variable name It would take way too much time and typing to explain why I want to do it this way....But the main one is; I want to be able to pull up the right sheet no matter what the user renames the sheet to. And yes...I do want to allow the user to do this. for example... for i = 1 to 10 sheetname = "sheet" & i thisworkbook.sheetname.blah.blah <do this next i of course, this method will not work...but has anybody a way to accomplish the same task, but in a different strategy? Much appreciated ricky |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Runtime Error '91' Object variable or With block variable not set | Excel Discussion (Misc queries) | |||
Object Variable Not Set Error on Selection object | Excel Worksheet Functions | |||
object variable or with block variable not set | Excel Discussion (Misc queries) | |||
Error 91 - Object variable with block variable not set | Excel Programming | |||
Object Variable or With Block variable not set? | Excel Programming |