View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
 
Posts: 811
Default 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 *