Macro runs correctly when run from Editor, but not from Command Button??

Hi,

This is very strange. I have this code within a larger macro to insert blank rows after subtotals:

Please Login or Register  to view this content.

When I run the entire Macro from the VBA Editor window, everything works correctly, including the insert rows after subtotals portion of it.

However, I have a Command Button set up as well, it looks at checkboxes to determine which Macro should be run. When I check the "Jan" checkbox and hit the Command Button, it performs the entire macro successfully EXCEPT for the portion where it's supposed to insert rows after subtotals. That part of the macro is in the middle of the larger macro, so it's like it's skipping that part??

Here is the code for the Command Button for reference: (Jan is Checkbox1).

Please Login or Register  to view this content.

Any ideas why it's skipping that one part of the larger macro when using the Command Button?

Thanks.

Never mind, figured it out. The Jan sheet has to be the active worksheet for the subtotal function to work.