Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error macro is 111K. how do I fix macro
How can I fix the macro to run. I know 64K is the maximum allowed so how can
split into two macro? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error macro is 111K. how do I fix macro
Using my x-ray vision and psychic abilities, I have determined you can reduce the size of your code by eliminating all of the "Select" statements and also looping thru cell ranges instead of specifying each cell that you need to change. After doing the above, splitting the code will be easier to accomplish and may even not be needed. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Dricon1" wrote in message How can I fix the macro to run. I know 64K is the maximum allowed so how can split into two macro? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error macro is 111K. how do I fix macro
Hi,
I am surprised that you can write a macro of this size in the first place. You to make it easier to debug, I generall ybreak the code into several sub-routines like: sub Main() call Initiate call get_Input call Process call Cleanup end sub Chances are that each of these Sub-routines will again be broken down further, and will call internal Functions to simplify the code further. A proper, logical design makes coding and debugging so much easier. Hope this helps. And there will usually be a number of internal Functions. -- Gerd "Dricon1" wrote: How can I fix the macro to run. I know 64K is the maximum allowed so how can split into two macro? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password Protect Macro - Compile Error | Excel Discussion (Misc queries) | |||
Using "Countif" in macro gives compile error | Excel Discussion (Misc queries) | |||
Macro Compile Error | Excel Programming | |||
Macro / Compile Error / Duplicate Declaration | Excel Worksheet Functions | |||
macro compile error | Excel Programming |