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?