Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi guys,
I'm finishing up a macro and need to store the name of the macro in a variable. I want the macro to find out what worksheet the user is on, execute the program which in this case is a webquery (which runs on a specific worksheet), and return to the worksheet that the user was originally looking at. I'm thinking that the best way to do this is to first set a variable to the name of the active worksheet, execute the program, and lastly to activate the original worksheet by using the variable that was set in the first operation. What do you guy think? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
store variable | Excel Programming | |||
How to store current row into variable | Excel Programming | |||
How to store text to variable | Excel Programming | |||
Store Variable with Exported Worksheet | Excel Programming | |||
Store variable value for Chart | Excel Programming |