Excel: Macro Error Using Split Function if Range Off Screen

 Last reviewed: November 30, 1994
Article ID: Q80370
The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
  • Microsoft Excel for OS/2 versions 2.2, 2.21, and 3.0

SUMMARY

When using the Split command in Microsoft Excel, where the column split or the row split refers to an area off the visible screen, a macro error will occur. It is not possible to manually set a split off the visible screen; nor is it possible to do this in a macro. This is by design.

MORE INFORMATION

Steps to Reproduce the Macro Error

  1. Enter the following on a macro sheet: 

          A1:=Split(1,1)          B1:=Split(250,2500)
      A2:=Return()            B2:=Return()

  2. Select A1. From the Macro menu, choose Run.

  3. Choose OK. A split will occur after column 1 and row 1.

  4. Select B1. From the Macro menu, choose Run.

  5. Choose OK.

A macro error will occur because the column 250 and row 2500 are off the screen.

REFERENCES

"Microsoft Excel Function Reference," version 3.0, page 227

KBCategory: kbother
KBSubcategory:

Additional reference words: 5.00 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0
3.00 4.0 4.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.