VBA is crashing after about 350 pages

macropod · #4 03-06-2018, 03:41 PM

Quote:

Originally Posted by lars-daniel

Latest (and biggest) Intel i7 with latest Office still uses 1 core only, three cores (+ hyperthreading) are idling. I should better split it into single files and run in parallel

Splitting the document into multiple files won't help unless you also start multiple independent Word sessions.

Quote:

Originally Posted by lars-daniel

Oops, it doesn't work every time. I've got very much cells, which haven't get touched at all.

In that case, there's more than just -1 in the cells (e.g. some spaces). You might try changing:
Split(.Range.Text, vbCr)(0)
to:
Trim(Split(.Range.Text, vbCr)(0))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Numbering with heading is mixed up in odd pages in regard to even pages	Baflla	Word	0	09-11-2016 05:25 AM
Multiple Master Pages dont sync with content pages	generatorjoe	Publisher	0	07-28-2016 10:12 AM
Spreadsheet keeps crashing	SavGDK	Excel	8	06-28-2016 08:27 AM
Office 2013 is crashing and renaming files when crashing	Brewski	Office	1	09-21-2015 09:04 PM
Advanced page numbering: section pages in header, document pages in footer	Albus	Word	12	12-12-2014 01:36 PM