View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
 
Posts: 812
Default Testing CF Conditions

I stepped through the code and when it got to the line:
IsCFMet = rng.Value = oFC.Formula1
rng.Value = Empty, not the same as =""

I changed your 2nd condition to Formula Is: = ISBLANK(A2) = TRUE
and IsCFMet() returned TRUE.

Hth,
Merjet