Formula throwing up an error
 

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

What kind of error are you getting? (Klunk!)

If it is a syntax error, I think you want (untested):

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

In other words, each double-quote that is intended to be a character in the
string must be written as two double-quotes.

That is simply the most obvious error. There might be others, once you fix
that one.


----- original message -----

"Gotroots" wrote in message
...
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.