View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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.