Detect blank 'rows' in a selected range using excel vba
Posted on 2014-10-17
I would like to run a macro that performs the following action:
For the selected range, check whether there are blank rows. If so ...
... display them in a msgbox such as "rows 4, 13, 1578 are blank rows" and ...
... select them.
For example: Range A2 to D40 is selected
If the macro detects that A4, B4, C4, D4 are blank cells, the macro would come up with the msgbox: Row 4 is blank
I hope this is feasible. Help is much appreciated.
Thank you very much in advance for your valuable and professional help.