S
samcham
I've been using Ron DeBruin's "Create separate sheet for each horizontal
PageBreak" script (http://www.rondebruin.nl/hpagebreaks.htm) for a while, and
it usually works for me. But this time, it just locks up Excel 2003.
The only thing I can think of that's different is that this worksheet
contains subtotals, where the others didn't. With the subtotals, it's over
6,000 lines long, and goes to column AE. The page breaks are in place. The
only edit I've made to the script is to include columns A through AE.
Does anyone have any ideas about what might be causing this behavior? Do
the subtotals have anything to do with it? If so, is there a workaround?
PageBreak" script (http://www.rondebruin.nl/hpagebreaks.htm) for a while, and
it usually works for me. But this time, it just locks up Excel 2003.
The only thing I can think of that's different is that this worksheet
contains subtotals, where the others didn't. With the subtotals, it's over
6,000 lines long, and goes to column AE. The page breaks are in place. The
only edit I've made to the script is to include columns A through AE.
Does anyone have any ideas about what might be causing this behavior? Do
the subtotals have anything to do with it? If so, is there a workaround?