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