Dear all,
I have a question regarding a spreadsheet I have. I have already searched other threads but I can't find any helpful solution (since it's quite complex).
I do not know a lot about macro's and would need a macro to automatically hide rows if the row is empty (some rows do contain IF formulas which return value "") and to unhide if the row suddenly contains a value (due to a value returned by the IF formulas).
I have found examples of this but they only apply to adjecent rows or give example of only one row. I do however need to hide multiple rows at once when empty. In my specific example: 24, 25, 26, 27, 28, 31, 32, 52, 53, 57, 58, 112, 113, 114, 115, 125, 126, 127, 128, 131, 135, 136 need to be hidden if empty or pop-up if not empty. So...:
Can this be done in one single macro?
Can this be done automatically or do I have to make a 'button' to activate the macro?
As mentioned previously, I'm new to the macro-thing and would really appreciate any advice
Thank you in advance!
Maxioliv
I have a question regarding a spreadsheet I have. I have already searched other threads but I can't find any helpful solution (since it's quite complex).
I do not know a lot about macro's and would need a macro to automatically hide rows if the row is empty (some rows do contain IF formulas which return value "") and to unhide if the row suddenly contains a value (due to a value returned by the IF formulas).
I have found examples of this but they only apply to adjecent rows or give example of only one row. I do however need to hide multiple rows at once when empty. In my specific example: 24, 25, 26, 27, 28, 31, 32, 52, 53, 57, 58, 112, 113, 114, 115, 125, 126, 127, 128, 131, 135, 136 need to be hidden if empty or pop-up if not empty. So...:
Can this be done in one single macro?
Can this be done automatically or do I have to make a 'button' to activate the macro?
As mentioned previously, I'm new to the macro-thing and would really appreciate any advice
Thank you in advance!
Maxioliv
