| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste Special throwing an error | Excel Discussion (Misc queries) | |||
| Build Pivot Table with VBA; Keeps Throwing an Error | Excel Programming | |||
| copy and insert throwing error- help in code req | Excel Discussion (Misc queries) | |||
| aconcat UDF throwing a #NAME error | Excel Worksheet Functions | |||
| Throwing an error ... on purpose! | Excel Programming | |||
Hybrid Mode
