Range End(x1up) problems

[Paul Lambson]

I am trying to select the last cell in collum then offset one row down
to paste an object. I keep getting an error. What am I doing wrong?

Range(Range("AH").End(x1down).Offset(1, 0)).Select

Thanks in advance,
Paul

 

[Andrew Taylor]

There are at several problems here::

- x1Down should be xlDown (with a letter L, not number 1)
- Range("AH") is not valid - you probably mean Range("AH1") (or maybe
Range("A8")?)
- You don't need the outer Range function, as the End and Offset
methods
return a Range object.

So Range("AH1").End(xlDown).Offset(1, 0).Select should do the trick

 

[Mike H]

Paul,

To be sure its the last cell look from the bottom up with this


Range("AH65536").End(xlUp).Offset(1).Select

Mike

 

[Gary''s Student]

Sub ordinate()
Range("AH" & Cells(Rows.Count, "AH").End(xlUp).Row + 1).Select
End Sub