sheets("sheet2").cells(rows.count, "A").end(xlup).offset(1,0).select

--
HTH...

Jim Thomlinson


"sungen99" wrote:


Just need a simple macro please.

goto sheet2 and place the cusor at A(whatever is the last line of data
+1)


thanks very much.


--
sungen99
------------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=540357