Hidden rows
I have a macro which prepares a report using subtotals and hides all rows
without data, and another that clears the subtotals. It was working well, but now for some reason the hidden rows are still hidden. I have been unable to bring them back by manually clearing outlines, ungrouping or unhiding rows or by formatting the row heights to 12.75. The row numbers of my named area are in blue. I can see the rows by clicking between the numbers and dragging the rows apart, but they are still in blue. What have I done wrong? |
Hidden rows
Possibly, you could use this line before your procedure ends:
ActiveSheet.Rows.EntireRow.Hidden = False HTH Regards, GS |
Hidden rows
Thanks for the reply. I had tried that and it didn't work. I have since
found the answer by scrolling through similar questions elsewhere. I had introduced a filter which seemed to lock the hidden cells and by including a 'ShowAll' in my code I have overcome the problem. "GS" wrote: Possibly, you could use this line before your procedure ends: ActiveSheet.Rows.EntireRow.Hidden = False HTH Regards, GS |
Hidden rows
Oh! You didn't mention about the filter. -Glad you figured it out though!
Regards, GS "pkeegs" wrote: Thanks for the reply. I had tried that and it didn't work. I have since found the answer by scrolling through similar questions elsewhere. I had introduced a filter which seemed to lock the hidden cells and by including a 'ShowAll' in my code I have overcome the problem. "GS" wrote: Possibly, you could use this line before your procedure ends: ActiveSheet.Rows.EntireRow.Hidden = False HTH Regards, GS |
All times are GMT +1. The time now is 05:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com