Selection.End(xlDown).Offset(1,0).Select


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Pitbull" wrote in message
...
Hello all, just trying to copy a range after the last used
cell in a worksheet.

I use the recording macro to do it.

Stuck after this step.:

Selection.End(xlDown).Select
(Now, I need it to go down 1 more row)... but if I do it
with the keyboard, it just says, range select (a specific
cell)
What is the command to say, down one more row please?

Tx

Pitbull