There are at several problems he:

- 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





On 11 Jan, 16:19, Paul Lambson wrote:
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