Felisca,

You would be better off posting an explanation of what the macro does, step by step. It's been way too long since I program Lotus to
remember what the keystrokes do.....

HTH,
Bernie
Excel MVP


"Felisca Wiratama" wrote in message ...
Can anyone help to translate the following macro in Lotus 1-2-3 to Excel
?
\p /AI~/PSWY
{ESC}G
\a {HOME}/AI~
{GOTO}A171~{?}
{HOME}/PGQ
/Q
\s /FS~R
\w \RVE27..E38~
G27~{BRANCH \C}
\n \AI~\PSE3~
WYQ\PG\Q
\c {GOTO}YTD~
\RV~{U}~

Thanks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!