![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Guest
Posts: n/a
|
I am new to Lotus 1-2-3 Macro. Could any one just explain some simple 1-2-3 Macro to me?
{R}+ n19{R}+n20{R}+n42{R}+n43{R}~ /RV{L}{L}{L}{L}~{L}{L}{L}{L}~ What does these mean? I know /RV is to change formula to value. {R} is to move cursor right and {L} left. But i still can't fully understand the previous codes. What's the meaning of ~ ? |
|
|
|
#2 |
|
Guest
Posts: n/a
|
~ (Tilde) is a 'Return' in Lotus 123 Macros
|
|
|
|
#3 |
|
Guest
Posts: n/a
|
so the code {L}{L}{L}{L}~{L}{L}{L}{L}~
doesn't make sense, right? after {L 4}~ , execution has returned to Macro, how can {L 4}~ repeat ? |
|
|
|
#4 | |
|
Guest
Posts: n/a
|
Quote:
It is merely mimicing the Lotus keystrokes .. give it a try /RV etc.. I hope this helps some, if I may suggest this is an Excel forum but there is another for Lotus on this site too .. just a suggestion. Sam |
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|