Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Range name problems | Excel Discussion (Misc queries) | |||
Date Range problems | Excel Programming | |||
Range problems... | Excel Programming | |||
Range problems | Excel Programming | |||
Variables and range problems | Excel Programming |