LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 173
Default subtotal efficiency problem

In a workbook under construction, I have two separate sheets containing
macros that subtotal various rows and run a loop to hide zero-value rows.

Neither page is of any size at all, both being about 200 rows and 12 columns
of data.

The macros have different subtotal parameters, therefore one will not suffice.
They are similarly named, with an abbreviation of their respective sheet
names at the end -- ie SubtotalDetail() and SubtotalExps() .

One -- SubtotalDetail() -- was created in the original workbook
[Master.xlsm], and runs efficiently.

The other -- SubtotalExps() -- was created in its own workbook, and has been
moved into Master.xlsm, along with its module.
This completes its task properly, but runs extremely slow.
There are no errors, no remaining links to its original workbook, and the
macro is running from its own module in the Master workbook.

... But again, runs excruciatingly slow, when the other macro --
SubtotalDetail() --containing almost-identical code and being more
resource-intensive -- runs quickly and efficiently.

Both are merely called from a button.

Does anyone have any ideas what the problem is, and hopefully how to remedy
it?

Thanx in advance,
- Mike

 
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
Subtotal Problem Salman Excel Worksheet Functions 3 March 29th 07 10:08 AM
Excel Subtotal problem gmasson Excel Worksheet Functions 1 January 23rd 06 07:18 PM
Subtotal & #n/a problem [email protected] Excel Programming 3 December 16th 04 07:43 AM
subtotal problem pcscsr[_6_] Excel Programming 0 November 1st 04 09:49 PM
subtotal problem pcscsr[_5_] Excel Programming 1 October 31st 04 10:54 PM


All times are GMT +1. The time now is 08:44 AM.

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

About Us

"It's about Microsoft Excel"