help in syntax

[Guest]

I am trying to write the following formula into cell.

.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=IF(COUNTIF("&rRange & "," & sCell&")>1,TRUE,FALSE)"

where rRange and sCell are range variables.
I got syntax error.
Would anyone help?

Thanks in advance.

 

[Ajtb]

Hi
I think this will work.

..FormatConditions.Add Type:=xlExpression, Formula1:= _
"=IF(COUNTIF(rRange , sCell)>1,TRUE,FALSE)"


Regards
Andrew Bourke

 

[Bob Phillips]

You don't give us much help, but assuming that rRange is a range variable
and sCell is a string variable setup earlier in the code, you could try

.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=IF(COUNTIF(" & rRange.Address & ",""" & sCell &
""")>1,TRUE,FALSE)"

--

HTH

RP
(remove nothere from the email address if mailing direct)