Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Putting a Snippet of Text in a Cell | Excel Discussion (Misc queries) | |||
Newbie needs help deciphering formula. | Excel Worksheet Functions | |||
converting Lotus 123 macro to Excell macro | Excel Discussion (Misc queries) | |||
MaxRows 65536 in a sheet - A Code Snippet | Excel Programming |