VBA If Statement value question

[Pinaceous]

Hi All,

If I have the IF statement below:

If Range("H11") = "" And Range("I11") = "" Then

This indicates that both cell values are blank.

How would I rewrite this IF statement above whereby both cells have values ?

For example, if H11 has a number value present and if I11 has a number present.

Thank you!
pinaceous

 

[Micron]

Don't understand the question. Maybe use Not?
If Not Range("H11") = "" And Not Range("I11") = "" Then

which means there IS something other than "" in both cases.

 

[dave3009]

Hi, if both must contain a number then you can try

If IsNumeric(Range("H11")) And IsNumeric(Range("I11")) Then

 

[Pinaceous]

dave3009!


Many thanks!!!

pinaceous