Use .activate, preceded by the name of the sheet you want to activate
--
ve_2nd_at. Randburg, Gauteng, South Africa


"James C" wrote:


I am in sheet 1. I need a macro that will move me to sheet 2.
Can someone provide the code?

Thanx!

- Jim


--
James C
------------------------------------------------------------------------
James C's Profile: http://www.excelforum.com/member.php...o&userid=12114
View this thread: http://www.excelforum.com/showthread...hreadid=477584