Formula throwing up an error
 

Look at where your double quotes are located; each set surrounds something
that Excel will treat as a single string. Also, you will need a "&" between
each string or variable.

"=IF(SUM(--('A Use'!A$1:A$10000&'A Use'!C$1:C$10000=B10&"


"Gotroots" wrote:

Can anyone tell me why I should be getting an error.

Range("L10:L7800").FormulaArray = "=IF(SUM(--('A Use'!A$1:A$10000&'A
Use'!C$1:C$10000=B10&"G house")),"G house","")"


B10 by the way is a relative reference.

Thank you for your time.