Posted to microsoft.public.excel.programming

mike

external usenet poster

Posts: 216

Why an error?

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error of slope taking into account error of the data points	cer144	Excel Worksheet Functions	5	July 7th 08 07:26 PM
Counting instances of found text (Excel error? Or user error?)	S Davis	Excel Worksheet Functions	5	September 12th 06 04:52 PM
I have Error 1919 Error Configuring ODBC dataSource Database	Texanna1	Excel Discussion (Misc queries)	1	September 12th 06 06:35 AM
Excel 2003 Macro Error - Runtime error 1004	Cow	Excel Discussion (Misc queries)	2	June 7th 05 01:40 PM

All times are GMT +1. The time now is 12:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us