Up 1 Row

[Guest]

Hey all...

Thanks for all the help guys!

Anyway, is there anyway to xlDown then up 1 row? Just Curious.

Thanks.

Tim

 

[Tom Ogilvy]

selection(1).End(xldown)(0).select

 

[Guest]

hi.
use the offset command
assuming A1 has ten rows of data and you want row 9.
range("a1").end(xldown).offset(-1, 0).select
where Offset(rows,columns)
rows - negative numbers = up & positive numbers = down
columns - negative = to left & positive = to right
0 = stay in same row/column.
In the example above go to the bottom of data in column A
then go up 1 row and stay in the same column. (-1, 0)