Compile error macro is 111K. how do I fix macro

[Dricon1]

How can I fix the macro to run. I know 64K is the maximum allowed so how can
split into two macro?

 

[Jim Cone]

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" <[email protected]>
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?

 

[gerdmain]

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.