I have a spreadsheet that has a macro that will hide rows (based on cell E9 to E88). This shortens the printing of the spreadsheet from 3 pages down to 1 or 2 in many cases.
However, I get a run time error '9', subscript out of range. I have tried just about everything to find the error. Almost ready to give up and start from scratch.
any help very much appreciated to point me to where the error could be. thanks. file attached.
Mel
TEST V5.xls
Bookmarks