ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help Deciphering a Lotus Macro Snippet (https://www.excelbanter.com/excel-programming/295717-help-deciphering-lotus-macro-snippet.html)

Raul[_4_]

Help Deciphering a Lotus Macro Snippet
 
Can anyone help me decipher the following snippet of a
Lotus macro?

{GOTO}AK5~
/CJ78..J78~{DOWN}~
/RVAD6..AK10~AD6..AK10~
{GOTO}AA2~

I'm pretty sure

{GOTO}AK5~
/CJ78..J78~{DOWN}~

is equivalent to copying the value of J78 to AK5 and then
moving down one cell.

It's the /RVAD6..AK10~AD6..AK10~ that has me guessing...

Is is converting the formulas in AD6:AK10 to values?

Thanks in advance,
Raul

Don Guillett[_4_]

Help Deciphering a Lotus Macro Snippet
 
Sure looks like it is converting to values
range value

--
Don Guillett
SalesAid Software

"Raul" wrote in message
...
Can anyone help me decipher the following snippet of a
Lotus macro?

{GOTO}AK5~
/CJ78..J78~{DOWN}~
/RVAD6..AK10~AD6..AK10~
{GOTO}AA2~

I'm pretty sure

{GOTO}AK5~
/CJ78..J78~{DOWN}~

is equivalent to copying the value of J78 to AK5 and then
moving down one cell.

It's the /RVAD6..AK10~AD6..AK10~ that has me guessing...

Is is converting the formulas in AD6:AK10 to values?

Thanks in advance,
Raul




Raul[_4_]

Help Deciphering a Lotus Macro Snippet
 
Thanks,
Raul
-----Original Message-----
Sure looks like it is converting to values
range value

--
Don Guillett
SalesAid Software

"Raul" wrote in

message
...
Can anyone help me decipher the following snippet of a
Lotus macro?

{GOTO}AK5~
/CJ78..J78~{DOWN}~
/RVAD6..AK10~AD6..AK10~
{GOTO}AA2~

I'm pretty sure

{GOTO}AK5~
/CJ78..J78~{DOWN}~

is equivalent to copying the value of J78 to AK5 and

then
moving down one cell.

It's the /RVAD6..AK10~AD6..AK10~ that has me

guessing...

Is is converting the formulas in AD6:AK10 to values?

Thanks in advance,
Raul



.



All times are GMT +1. The time now is 06:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com