Want a simple VBA code.
 

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

Want a simple VBA code.
 

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

Want a simple VBA code.
 

Another (more literal way)

ActiveCell.End(xldown).Offset(1,0).Select

--
Regards,
Tom Ogilvy


"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