I'm trying to hide data that occurs in the past. If I make a sheet from scratch it seems to work but the report I'm trying to adapt this to, seems to just stall and eventually crash Excel.
In my "WorkingReport" attachment, I have how my report is formatted (minus some sensitive data). This is the document that stalls when running essentially the same macro.
In my "Report" attachment, it works fine but it seems I have to strip a lot of the formatting & empty rows/columns away to make it work. This makes it very hard to look at and bland.
Any help would be appreciated.
FYI - Sorry I mislabelled my attachments. You would think the one named "WorkingReport" would work but that's the one that's broken![]()
Bookmarks