End of List

  • Thread starter Thread starter Ronbo
  • Start date Start date
R

Ronbo

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?
 
Hello, the following sub routine works for me

Sub a(): [c1].Resize(5).Copy [b65536].End(3)(2): End Su

Where I'm using 3 as constant for XlUp. And (2) is the shorthand for .item(2). Offset() would be equally functional

Regards
Nate Oliver
 
Back
Top