I would like a range of rows (66-113) to be hidden by default.
Scenario 1:
If a cell (e65) has a value entered, row 66 will be unhidden. If cell e66 has a value entered, row 67 will be unhidden and so on.
Scenario 2
As above, Rows 66-113 are hidden by default
User enters a number representing the number of rows to be unhidden in cell E7 - this number of rows is then unhidden commencing with row 66.
Can any one advise how to code either or both these scenarios?
Thanks
Ed
Bookmarks