View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Perry[_2_] Chris Perry[_2_] is offline
external usenet poster
 
Posts: 1
Default Pass multiple parameters through macros

I want to pass more than one parameter through a
procedure. Ex.
Sub AAAAquery()
Dim queryname
Dim querynumber
Dim testname


Sub BBBBquery()

AAAAquery (queryname)

I can pass the defined variable queryname through. I want
to add testname. Ex.
Sub BBBBquery()

AAAAquery (queryname, testname)
This does not work.