VBA - array formula functions ok until I use an If THEN either side?

[Loun]

Hello,

I'm sure this is something simple but its been driving me crazy trying to figure it out.

i have the below array formula in VBA. I'm trying to check if the value calculated is above 1..... If I leave off the IF part at one end and the >1 then at the other it prints the value correctly on spreadsheet.

However, when I put the IF part on to try to get it to calculate internally and check the value rather than print the value it is not recognising anything greater than 1.....

any ideas? In sure I'm missing something that states to check the value of the formula or something but I can't figure it out.

If Selection.FormulaArray = "=SUM(IF(CONCATENATE(RC[2],RC[1])=CONCATENATE(RC[2]:R[96]C[2],RC[1]:R[96]C[1]),1,0))" > 1 Then

many thanks

 

[Loun]

Jonmo,

Perfect! Thanks a million for taking the time to assist with this!

Thanks,
lou

 

[Jonmo1]

Glad to help, thanks for the feedback.