Hi

Is it possible to search a range of cells for empty cells? If there are any, then I want an error to pop up.

I.e I have a range called 'Appliance Details'. I have tried the following code (like i would do for a single cell):

If Range(Appliance_Details).Value = "" Then Err = "Cell(s) in Appliance Details are not filled in. Please check and fill in where needed."

However, it doesn't work.

I don't car how many empty cells there are. All I need to know is that there is at least one empty cell so I can prompt the user to go and check the range.

I would prefer to do it by range becuase doing by individual cell would take forever and not be of massive benefit for my needs.

If I am doing this in a stupid way I am always grateful for advice.

Thanks in advance