Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
All,
I'm running in to the following problem when using Edit / GoTo - as described by Microsoft. How can I create the workaround described? ======================================= CAUSE This behavior occurs if you select more than 8,192 non-contiguous cells with your macro. Excel only supports a maximum of 8,192 non-contiguous cells through VBA macros. Typically, if you try to manually select more than 8,192 non-contiguous cells, you receive the following error message: The selection is too large. However, when you use a VBA macro to make the same or a similar selection, no error message is raised and no error code is generated that can be captured through an error handler. WORKAROUND To work around this behavior, you may want to create a looping structure in your VBA macro that handles less than the maximum 8,192 cells. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
? IF & GOTO ? | Excel Worksheet Functions | |||
? IF and GOTO ? | Excel Worksheet Functions | |||
On Error GoTo Label in a loop only working once. | Charts and Charting in Excel | |||
VBA - using Goto - Please Help! | Excel Programming | |||
HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming |