Macro not working correctly

**erict** · 12-29-2010, 02:13 PM

Could someone help. I've got this macro that works great in one report. So I copy copy it and modify it a bit to use in another report, but it is not performing all the commands. The macro creates "fake rows" of data to keep the subtotal function from going haywire, but for some reason it is not deleting the "fake rows" of data after the subtotaling is complete or bolding the entire subtotal rows. I've attached the file.
Thank you for any help.

**Leith Ross** · 12-29-2010, 02:42 PM

Hello erict,

That workbook is a disaster. Somehow you have 3 sheets showing despite only 1 is shown in Excel objects. "Personal" has no data and has the macro code attached to the sheet. You have an empty module and 3 empty Class modules???

I copied the code from the "Personal" worksheet into Module1. I also turned off showing the formulas in the cells. When I run the macro on the sheet "Macro1" it appears correct. Check the attached copy on your system.

**erict** · 12-30-2010, 10:11 AM

Thanks for your time and thanks for cleaning up the macro mess. I'll use that one going forward. After pasting new data and executing the Macro1, I noticed a few things. The formula is shown in the subtotal row instead of the value, and the "fake rows" of data the macro should delete are still there. And, I noticed something else that has just started occuring after I received a new computer and it apperas here also - the marco now produces 2 grand total rows. I've attached the file with the executed macro if you have time to look at it. Thanks again for your help.