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?