Microsoft KB Archive/87741

{|
 * width="100%"|

Lotus Macros Using Direction Key Commands May Fail in Excel

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0, 5.0

-

SUMMARY
Macros created in Lotus 1-2-3 that use direction keys, or {GOTO} commands, may fail when running in Microsoft Excel.

MORE INFORMATION
Lotus 1-2-3 is a character-based full-screen application so its screen size is fixed at 20 rows by 8 columns. A Microsoft Excel document window can contain any number of rows or columns.

Direction key commands such as {PGUP} or {PGDN} and {GOTO} commands move the active cell based on the current page size, instead of the 20 row by 8 column Lotus 1-2-3 standard. As a result, the active cell may be moved to the wrong location, causing your macro to fail.

Workaround
For best results, size the active document window in Microsoft Excel to contain the same number of rows and columns that Lotus 1-2-3 has (20 rows by 8 columns).