Menu

macro {r 1} command in lotus

Search this Thread

Prev

Previous Post

Next Post

Next

#5

Report Post

Posted to microsoft.public.excel.programming

Don Guillett[_4_] Don Guillett[_4_] is offline

Don Guillett[_4_] is offline

external usenet poster

Posts: 2,337

Default

macro {r 1} command in lotus

I am guilty of these errors often.

--
Don Guillett
SalesAid Software

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
D'oh! Brain freeze.....

Thanks - at least somebody is reading this...

Bernie

"Don Guillett" wrote in message
...
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.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Where is the Lotus transition key command?	bcolbert	Excel Discussion (Misc queries)	1	December 8th 08 02:43 PM
Is there an equivalent of Lotus 123's "Paste visible" command?	AJ	Excel Discussion (Misc queries)	6	March 16th 06 09:21 AM
Using Lotus 123 command in excel 2003	Rao Ratan Singh	Excel Discussion (Misc queries)	2	August 28th 05 11:49 PM
converting Lotus 123 macro to Excell macro	mark h	Excel Discussion (Misc queries)	6	July 11th 05 01:28 PM
Lotus 1-2-3 macro	Felisca Wiratama	Excel Programming	2	July 9th 03 08:35 PM

All times are GMT +1. The time now is 03:59 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement