"Mike123 " wrote...
I have a pretty complex macro that I am trying to convert into Excel.
I have tried to convert this Lotus Macro but to work in Excel but just
can't seem to get any luck doing this. I am not sure if this is the
correct area to look for any help in debugging this macro.

I will be happy to post this Macro if anyone would like to take a shot
at converting it into excel?
....

I'll take a shot at it. I've done a few of these myself. If there are lots
of {?}, {GET} or {LOOK} calls, a ground-up rewrite would be a better idea.

The best way to display 123 classic macros that use a lot of defined names
is to use the first few character positions on each line for range names,
and start all macro code a few more character positions to the right of
that. And show defined names used as variables. For example,

_CNTR_ = A:A1

\A: {for _CNTR_,0,10,1,\A_SUB}
{return}

\A_SUB: {d}{edit}{home}'~
{return}