Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
Code to create a list of records in another sheet, based on the entryof the word "Terminated" in a given column | Excel Programming | |||
How to update a "master" spreadsheet every time I create a newworkbook or a new sheet | Excel Worksheet Functions | |||
Modifying Ron De Bruin's "Create summary sheet from different workbooks" | Excel Programming | |||
create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions |