M
MusicMan
I am an old lotus guru that is lost in VBA.
Can someone convert the following simple lotus macro to VBA? It compares
two values and moves one set or the other if not matched to align two series
of data. "\b" compares debits, "\c" then compares the credits. 5 minutes work
in lotus, years of frustration in excel! Hope there are still some old
123pro's out there who'll understand this.
\a {goto}e17~
\b /xi@cellpointer("contents"}=""~{r}/xg/c~
/c~hold~
{right 4}~
/xi@cellpointer("contents")=hold~{down}{left 4}~/xg\b~
/xi@cellpointer("contents")<hold~{left 8}/m{end}{d}{r 5}~{d}~{d}{r 4}/xg\b~
/m{end}{d}(right 3}~{d}~{d}{left 4}/xg\b~
\c /xi@cellpointer("contents"}=""~/xq
/c~hold~
{right 4}~
/xi@cellpointer("contents")=hold~{down}{left 4}~/xg\c~
/xi@cellpointer("contents")<hold~{left 9}/m{end}{d}{r 5}~{d}~{d}{r 5}/xg\c~
{left}/m{end}{d}(right 3}~{d}~{d}{left 3}/xg\c~
Can someone convert the following simple lotus macro to VBA? It compares
two values and moves one set or the other if not matched to align two series
of data. "\b" compares debits, "\c" then compares the credits. 5 minutes work
in lotus, years of frustration in excel! Hope there are still some old
123pro's out there who'll understand this.
\a {goto}e17~
\b /xi@cellpointer("contents"}=""~{r}/xg/c~
/c~hold~
{right 4}~
/xi@cellpointer("contents")=hold~{down}{left 4}~/xg\b~
/xi@cellpointer("contents")<hold~{left 8}/m{end}{d}{r 5}~{d}~{d}{r 4}/xg\b~
/m{end}{d}(right 3}~{d}~{d}{left 4}/xg\b~
\c /xi@cellpointer("contents"}=""~/xq
/c~hold~
{right 4}~
/xi@cellpointer("contents")=hold~{down}{left 4}~/xg\c~
/xi@cellpointer("contents")<hold~{left 9}/m{end}{d}{r 5}~{d}~{d}{r 5}/xg\c~
{left}/m{end}{d}(right 3}~{d}~{d}{left 3}/xg\c~