Thread: Formula throwing up an error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gotroots Gotroots is offline
external usenet poster
  
Posts: 114
Default Formula throwing up an error
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.
Reply With QuoteReply With Quote