asked on

Detect blank 'rows' in a selected range using excel vba

Dear Experts:

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.

Regards, Andreas

SOLUTION

Professor J

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Farzad Akbarnejad

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Professor J

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

[ fanpages ]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Andreas Hermle

ASKER

Dear Experts,

wow, thank you very much for your overwhelming support. This forum is just great.

All of the approaches work just fine, thank you very much but to be honest with you if I do a ranking, which ones are the best and the second best, then the ranking is: 1. fanpages (excellent) and 2. farzad

Will do the point awarding shortly.

Again thank you very much for your professional support. I really appeciate it.

Regards, Andreas

[ fanpages ]

You are very welcome, Andreas.

I am glad I could help.

Andreas Hermle

ASKER

Again, thank you very much for your great and professional support. It is really hard to award points, since all solutions work.