View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
samcham samcham is offline
external usenet poster
 
Posts: 12
Default Trouble with "Create separate sheet for each horizontal PageBreak"

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?