I think I need a VBA solution, as I would like to do it for all sheets in the workbook.
Actually, the reason why is that I have noticed a problem/bug with hiding rows. Where all rows beneath a chosen area have been hidden, so that the available excel window is reduced - i.e. it doesn't scroll all the way to row 65536 - it doesn't seem possible to unhide these rows.
In the attached sheet, it is not possible to unhide any rows past 67, effectively limiting excel.
Anybody experienced this before or knows a fix?
**EDIT - Can't attach file as it is 75KB despite having nothing visible (cleared all formats and values) **
Last edited by MisterT; November 4th, 2004 at 22:55.
Reason: Can't attach file
Video Tutorials / Excel Dashboards Reports