View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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