Thread: Sheet number variable
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mikey10[_5_] mikey10[_5_] is offline
external usenet poster
  
Posts: 1
Default Sheet number variable

Thanks for responding Deepak Agarwal


Basically, to select say sheet 3 in a macro I would write:

Sheets("Sheet3").Select

But say the sheet number is actually a variable called 'Count'.

I need to be able to select the sheet of number 'Count'.
ie. If 'Count' = 5, then I need a macro that selects sheet 5.

Hope this makes more sense,

Thanks for your help,

Mik

--
mikey1
-----------------------------------------------------------------------
mikey10's Profile: http://www.excelforum.com/member.php...fo&userid=1537
View this thread: http://www.excelforum.com/showthread.php?threadid=27008

Reply With QuoteReply With Quote