macro {r 1} command in lotus
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.
|