Trying to Write Excel formula in VBA

[nirvehex]

Hi,

I'm trying to write an excel formula in VBA which gives me a unique count of a certain column. However, I'm getting an #N/A when I write it in VBA.

Any thoughts?

Here's the part that's giving the #N/A in the code:

.Range("B" & NumberofRows + 4).Formula = "=SUM(IF(FREQUENCY(MATCH($B$3:$B$" & NumberofRows & ",$B$3:$B$" & NumberofRows & "),MATCH($B$3:$B$" & NumberofRows & ",$B$3:$B$" & NumberofRows & ",0))>0,1))"

Thanks!

 

[RoryA]

It looks like you should be using Formulaarray and not Formula.

 

[nirvehex]

Thanks Rory, unfortunately using FormulaArray produced the same #N/A.

 

[RoryA]

It looks like you are missing a ,0 from the end of your first MATCH function.

 

[De Bruce]

Use double quotes for your string
"",$B$3:$B$""