Microsoft KB Archive/120733

{|
 * width="100%"|

Error Running Lotus 1-2-3 Macros with 3-D References

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0, 5.0

-

SYMPTOMS
When you run a Lotus 1-2-3 macro in Microsoft Excel, you may receive a macro error if the macro contains a reference to another worksheet ply. A Lotus 1-2-3 macro written in Lotus version 3.x and later may have commands that refer to other worksheet plies.

CAUSE
The Microsoft Excel macro interpreter is compatible only with macros written in Lotus 1-2-3 version 2.01 or earlier. Because version 2.01 of Lotus 1-2-3 does not recognize sheet names, the macro interpreter does not recognize these additional characters within a reference.

Multi-ply (3-D) Lotus workbooks are a feature of Lotus 1-2-3 versions 3.0 and later; therefore, the macro interpreter is not compatible with, and will not interpret, sheet addresses with 3-D references.

WORKAROUND
To work around this problem, open the macro in Microsoft Excel and remove the sheet reference. For example, edit the following macro

  /Rva:a6..a:d6~a:a9~ to read: 

  /Rva6..d6~a9~ The macro should now run correctly.