Translate formula into VBA
 

I have a simple formula that I would like incorporate into my vba to
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.


--
shternm
------------------------------------------------------------------------
shternm's Profile: http://www.excelforum.com/member.php...nfo&userid=858
View this thread: http://www.excelforum.com/showthread...hreadid=486017

Translate formula into VBA
 

How about

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

--

HTH

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


"shternm" wrote in
message ...

I have a simple formula that I would like incorporate into my vba to
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.


--
shternm
------------------------------------------------------------------------
shternm's Profile:
http://www.excelforum.com/member.php...nfo&userid=858
View this thread: http://www.excelforum.com/showthread...hreadid=486017