Want a simple VBA code.

  • Thread starter Thread starter madhu
  • Start date Start date
M

madhu

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
 
Cells(Rows.Count,"A").End(xlUp).Offset(1,0).Select

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Another (more literal way)

ActiveCell.End(xldown).Offset(1,0).Select
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting Till last row 1
Word VBA for deleting Selected Row 0
Delete summary rows programmatically 3
Trouble Installing Excel VBA Code Cleaner into Office 365 0
Excel VBA 1
Is there a command in visual basic to move down one space, e.g. m. 1
Excel VBA help: Text file formatting 19
Macro that will insert a simple text string in top cell of text file 1

Back
Top