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

Sheet number variable
 

Have you tried:

Sheets(Count).Select

Count must be an integer, greater than or equal to 1 and less then or equal
to activeworkbook.sheets.count

"mikey10" wrote:


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,

Mike


--
mikey10
------------------------------------------------------------------------
mikey10's Profile: http://www.excelforum.com/member.php...o&userid=15378
View this thread: http://www.excelforum.com/showthread...hreadid=270084

Sheet number variable
 

Hi

I think I am getting at what you are after!

Try this :-

Presuming that the variable containing the desired sheet number i
'Count' and the value of 'Count' now is say 3 - hence your macro shoul
select the 3rd worksheet in your workbook an name it as 'Week3', the
this would perhaps help :-

Worksheets(Count).select
activesheet.name = "Week" & Count


This will select the 3rd worksheet in the workbook starting from th
first worksheet beginning from left.

See if this helps - otherwise let me know and I will see if I can offe
further assitance.


Best regards


Deepak Agarwa

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