Hi Paul,

I've been struggling with the Splitting documents VBA macro for a while - testing and
debugging code is really time consuming and can be really frustrating, especially
when sometimes the error just won't go away, typical example vis a vis 5152.

Splitting files by copying and pasting them into new docs is something I do all the
time.

Today I had a big file - and that really made me struggle for an hour with the mouse,
highlighting , dragging to get the right text, to then copy and paste into 20
documents. Yikes!

So thank you very much for this Macro - its a diamond!

I have no doubt many people will benefit from this macro its a common task to split documents up - sometimes the idea
seems simple enough - but coding wise it can be a lot of code to deal with and
having the wisdom to know what goes where and when, when confronted by stubborn errors does make it stressful.

Thanking you again for your generous help, and sharing your time and expertise
and coding skills to help others.

I am really happy - as I have so many documents waiting to be split, I can go and
finish them all.

Not too fussed about the 5152, I can live with that, until Microsoft fixes it with some update or so.

Please mark as solved!

Have an super awesome week!

J

Also you saved me the hassle of inserting sections in each document before splitting - one less task for me to do - as they say every little helps!

Thank you


J