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
|