Excel: Macro Error Using Split Function if Range Off Screen

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

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

Keywords :
Version :
Platform :
Issue type :


Last Reviewed: March 23, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.


Send feedback to MSDN.Look here for MSDN Online resources.