End of List

T

Tom Ogilvy

assume the activecell is in the list, but not at the end

activecell.End(xldown).select
 
R

Ronbo

-----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?
 
Top