or in the case of moving to the RIGHT
offset(0,5)

--
Don Guillett
SalesAid Software

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Ed,

Activecell.Offset(#rows,#columns).Select

So the same as {r 5} would be

Activecell.Offset(5,0).Select

But there is hardly ever any reason to actually select a cell.....

HTH,
Bernie
MS Excel MVP


"Ed" wrote in message
...
Lotus had a command that allowed you to move the cursor within a macro.
The
comand was {r 5} which would move the cursor -right 5- from the current
location. Excell seems to record the keystroke movement into a specific
cell
reference within the macro. I see you can do a similar command with
"Selection.End(xlDown)" but I want to move a defined # of cells. not to
the
end of a range. Any bhelp would be appreciated.