Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subtotal Problem | Excel Worksheet Functions | |||
Excel Subtotal problem | Excel Worksheet Functions | |||
Subtotal & #n/a problem | Excel Programming | |||
subtotal problem | Excel Programming | |||
subtotal problem | Excel Programming |