Hi,

Try this

ActiveCell.FormulaArray = "=IF(MAX(COUNTIF(A3:A12,A3:A12))1,""Dup's""," "No
Dup 's"")"

Mike

"miek" wrote:

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"")}"