End of List

  • Thread starter Thread starter Ronbo
  • Start date Start date
assume the activecell is in the list, but not at the end

activecell.End(xldown).select
 
-----Original Message-----
Click to expand...

I am looking for a formula that will go to the end of a
list and then one line below, this would be the next open
line that I would like to paste info to.

Using...

Columns("B:B").Select
ActiveCell.End(xlDown).Select

takes me to the upper left cell that has contents.

Any suggestions?
 
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

Run Macro If Cell have "x" value 0
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Prgrammatically added OLE Listbox, now cannot select from it 9
Datavalidation with shrinking non blank values 1
Anyone Else Facing Public Folder Migration Errors in Exchange? 0
Combine 2 columns in a dynamic range into one 7
Run macro from active workbook whose name keeps changing 20
Convert list to UPPER, lower & Proper cases. 21

Back
Top