Hi

Quite a simple problem really, but I just cant seem to figure ut out.
have a simple variable in a cell called "ShCount". I would like to writ
a macro that selects the sheet number that relates to the number in cel
'ShCount'. This is the code so far and the second line is not accepted.

Sheet = Range("ShCount")
Sheets(Sheet).Select

Any idea what I am missing?

Many thanks in advance
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