M
MikeF
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
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