View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bugman bugman is offline
external usenet poster
 
Posts: 1
Default Define worksheet as variable, then call in macro


Hello All,

I want to dim a worksheet name, and then later call it as a variable to
go to in another macro.

e.g.

Dim callworksheetname as worksheets
callworksheetname = bob

Call bobsaddress()
Activate.bob.worksheet

I know the above is wrong, but you can guess what i am getting at

Any help please?

J


--
bugman
------------------------------------------------------------------------
bugman's Profile: http://www.excelforum.com/member.php...o&userid=28999
View this thread: http://www.excelforum.com/showthread...hreadid=487283