Cells(Rows.Count,"A").End(xlUp).Offset(1,0).Select

--

HTH

RP
(remove nothere from the email address if mailing direct)


"madhu" wrote in message
...
Hi,

Could you please provide me with a VBA code to perform the following task:

There are records in a sheet and I need to move the Cell pointer to the
next
row after the last record. Right now i press CTRL+DownArrow and again
DownArrow. Need a VBA code which will do this.

Thankyou.

MADHU