Translate formula into VBA

  • Thread starter Thread starter shternm
  • Start date Start date
S

shternm

I have a simple formula that I would like incorporate into my vba t
loop through the document but it does seem to work.

=IF(COUNTIF($C$1:C20,C20)=1,C20," ")

ActiveCell
"=If(Countif($R[0]$C[1]:R[0]C[1],R[0]C[1])=""1"",R[0]C[1],"" "")"

Thanks in advance
 
How about

ACtivecell.Formula = "=IF(COUNTIF($C$1:C20,C20)=1,C20,""")"

--

HTH

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