A Lotus macro that I need to run in Excel

[Jeff Stanley]

Here is the macro that we ran in Lotus:

{IF SPEC="CH"}/RVSPECCH~DIMENSIONS~{CALC}:PRSPRESSCHART~G
{IF SPEC="AG"}/RVSPECAG~DIMENSIONS~{CALC}:PRSPRESSCHART~G
{IF SPEC="RR"}/RVSPECRR~DIMENSIONS~{CALC}:PRSPRESSCHART~G
{IF SPEC="BE"}/RVSPECBE~DIMENSIONS~{CALC}:PRSPRESSCHART~G
{IF SPEC="AB"}/RVSPECAB~DIMENSIONS~{CALC}:PRSPRESSCHART~G
{IF SPEC="MAGNELOO"}/RVSPECMAGNELOO~DIMENSIONS~{CALC}:PRSPRESSCHART~G
{IF SPEC="RV"}/RVSPECRV~DIMENSIONS~{CALC}:PRSPRESSCHART~G
{IF SPEC="KALAOO"}/RVSPECKALAOO~DIMENSIONS~{CALC}:PRSPRESSCHART~G
{IF SPEC="KALAGR"}/RVSPECKALAGR~DIMENSIONS~{CALC}:PRSPRESSCHART~G

If the range named SPEC="CH" - / range SPECCH was copied to the range named DIMENSIONS - and the range name PRESSCHART was printed. It kept running until it found a match. We need to have the macro look for a match from a long list of choices - we have many specs. Hope this is enough information? Thanks for your help!

 

[Iridium]

Try posting in the 'Excel Questions' forum

HTH

 

[Juan Pablo González]

Duplicate:

http://www.mrexcel.com/board2/viewtopic.php?t=68822