Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Pivot Table Data with Column "Sum" rather than "count" defa Johnny_99[_2_] Excel Discussion (Misc queries) 2 January 2nd 10 03:25 PM
Code to create a list of records in another sheet, based on the entryof the word "Terminated" in a given column Mike C[_5_] Excel Programming 0 May 15th 08 12:49 AM
How to update a "master" spreadsheet every time I create a newworkbook or a new sheet [email protected] Excel Worksheet Functions 3 December 27th 07 09:04 PM
Modifying Ron De Bruin's "Create summary sheet from different workbooks" Greg[_37_] Excel Programming 7 May 20th 07 11:47 AM
create links to check boxes marked "good" fair"and "bad" pjb Excel Worksheet Functions 3 April 20th 06 02:17 AM


All times are GMT +1. The time now is 06:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"