Calling a sub with a variable...
 

For instance... I have it so that my program lets the user select all available macros from a dropdown list... Hard coded for now. It stores their selection in a variable called varpick... So when I do this:

Call varpick

It doesn't like it. Is there any way I can call a subroutine with a variable? Please tell me there is!

Calling a sub with a variable...
 

"Gary Phillips" wrote in message
...
For instance... I have it so that my program lets the user select all
available macros from a dropdown list... Hard coded for now. It stores their
selection in a variable called varpick... So when I do this:

Call varpick

It doesn't like it. Is there any way I can call a subroutine with a
variable? Please tell me there is!

Hi Gary,

Try: Application.Run varPick

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *