Macro Halts and Returns Error at SIZE() Command

ID: Q51770

The information in this article applies to:

Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0
Microsoft Excel for OS/2, versions 2.2, 3.0

SUMMARY

A macro error occurs if the SIZE() function is used and the active sheet is currently maximized. To prevent this error, the SIZE() function should be preceded by a command that restores the window to its previous size.

For example:

Microsoft Excel 2.x through 4.0


   =FULL(FALSE)         Restores the window to its previous size
   =SIZE(264,264)

Microsoft Excel 4.0 and 5.0


   =WINDOW.RESTORE()     Restores the window to its previous size
   =WINDOW.SIZE(264,264)

Note: the information above also applies to version 5.0 only when using version 4.0 macro language.

REFERENCES

"Microsoft Excel Functions and Macros," version 2.1, pages 290,358
"Microsoft Excel Function Reference," version 3.0, pages 225-226
"Microsoft Excel Function Reference," version 4.0, pages 418-419

Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 4.0 4.0a 4.00a 5.0

Keywords :
Version :
Platform :
Issue type :