Range End(x1up) problems
 

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

Range End(x1up) problems
 

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

Range End(x1up) problems
 

Paul,

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


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

Mike

"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

Range End(x1up) problems
 

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

--
Gary''s Student - gsnu200764


"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