How to check if two cells in a range of four are not blank?

Hi,

Bit of a theory based question here.

I have a row of four cells and I want to run some code only if two of these cells are not blank.
The only possible outcomes are:

• all cells empty
• all but one cell empty
• all but two cells empty

Obviously I could build a messy if statement using Or's and And's to check for each of the possible possitive criteria matches (e.g: If A1 and B1 <> "" or A1 and C1 <>"" or A1 and D1 <>"" or B1 and C1 <>""... etc), but I was wondering if there's a neater way to do this...

Always looking to improve, any ideas appreciated.

Thanks, TC

Please Login or Register  to view this content.

That looks like a nice idea! Thank you.

I have a bit more code to write then I'll incoporate the above (couple of other criteria to check) and confirm back as solved.

Thanks again, TC

Appologies for the delay - the other bits took a bit longer than expected!

I'm having a bit of trouble with this code, it's returning an "Object doesn't support..." error:

Please Login or Register  to view this content.

I've checked each of the items that build up the range and they're returning the correct values (10,33:10:36 for example).
Am I trying to do too much in this one line of code?

Any help appreciated. TC

it's .worksheetfunction not .worksheetfunctionS!

Doh! Thanks. #feelinglikeadoofus!