| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why an error?
Thanks for your help!
-----Original Message----- Just as in XL, in VBA, quotation marks inside strings need to be doubled: Range("C9").Formula = "=SUMPRODUCT(--(Dec! A6:A20J3),-- (Dec!A6:A20<K3),--(Dec!B6:B20<""""))" (all on one line). In article , "Mike" wrote: Hi. Can you tell me why I am getting an error with the following statement? If I take the same formula and plug it into the worksheet, it works fine. Range("C9").Formula = "=SUMPRODUCT(--(Dec!A6:A20J3),-- (Dec!A6:A20<K3),--(Dec!B6:B20<""))" Thanks, Mike. . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error of slope taking into account error of the data points | Excel Worksheet Functions | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
| Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Threaded Mode
