Macro instead of formula

[Eric Hearn]

I want to use an 'if...then...else' block instead of the following formula:-

=IF(AND(A3="€",COUNT(C1:C10)<COUNT(B1:B10)),"Something","Something Else")

Could somebody supply me with the appropriate code?

T.I.A.

Eric Hearn

 

[Eric Hearn]

Part of my formula went missing in the previous post.
It should continue:-

(B1:B10)),"Something","Something Else")

Eric Hearn

 

[patrickmuldoon99]

if [a3] = "euro symbol" then
application.worksheetfunction.Count(C1:C10)
end if

You need to insert the euro symbol where it says "euro symbol"

you're formula by the way isn't correct, there should be another condition for the AND to have any effect

HTH

 

[SteveO59L]

Still missing

 

[Eric Hearn]

Hi Guys

Please see my second post above.

Thanks

Eric Hearn

 

[fairwinds]

Hi,

=IF(AND(A3="€",COUNT(C1:C10) < COUNT(B1:B10)),"Something","Something Else")

If Range("A3") = "€" And WorksheetFunction.Count(Range("C1:C10")) < WorksheetFunction.Count(Range("B1:B10")) Then
MsgBox "Something"
Else
MsgBox "Something Else"
End If

 

[Eric Hearn]

Hi

Looks good!

Thanks a lot

Eric Hearn