Posting in the next row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use the 'find' key to locate the column I want to make entries in, however
the column is getting too long and I have to page down to get to the first
empty row. Is there a way to use 'find' or another method to take me
directly to the last row in the desired column? Thks, Greg
 
It depends, if the column is filled all the way you can use ctrl + downarrow
otherwise you'll need to roll your own

Sub TestMe()
Cells(Rows.Count, ActiveCell.Column).End(xlUp).Offset(1, 0).Select
End Sub

will select the first empty cell after the last netry in a column


Regards,

Peo Sjoblom
 
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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
using the =page! feature to transpose a row to column 0
Delete rows based on contents of Col A 0
sum of multiple rows 2
Match value in one column and return value in same row in next col 2
Go To the next empty cell in Column A 3
Find next occupied row up in another column 9
Return to next row in first column when entering data in Excel 3

Back
Top