check if any cell in a dynamic range is empty

I need to make sure all the inputs are entered before running a macro. In order to do that, I would like to make sure none of the cells in the range (which is dynamic and I know the range) is empty. How to do that?

Thanks in advance, Anil

Here's what I would do. Assuming your dynamic range is named "named"

Please Login or Register  to view this content.

It counts the number of rows against the number of entries. Does that work for you?

ChemistB

Hello akabraha,

Here is another way. With this method you can identify the cells that are blank (empty). It will display a message box listing the cells that are blank.

Please Login or Register  to view this content.

Example

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Thank you ChemistB and Leith Ross (you are the Excel Guru). CountA worked for me.

Thanks again, Anil