Formula array
 

try this

ActiveCell.formulaarray= "=IF(MAX(COUNTIF(A3:A12,A3:A12))1,""Dup's""," "No
Dup's"")"
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"miek" wrote in message
...
How do I enter in the following as a formula array?
{IF(MAX(COUNTIF(A3:A12,A3:A12))1,""Dup's"",""No Dup's"")}
This does not work:
ActiveCell.Value = "{IF(MAX(COUNTIF(A3:A12,A3:A12))1,""Dup's""," "No
Dup's"")}"