Posted to microsoft.public.excel.programming

Dave

external usenet poster

Posts: 1,388

line continuation

Hi,
XL2003
I cannot use the < space Underscore line continuation on the following
line without generating an error.

Range("A1") =
"=SUMPRODUCT(--(B$2:B$445=B2)*(C$2:C$445=C2)*(D$2:D$445=D2)*(G$2: G$445=G2)*(H$2:H$445=H2)*(I$2:I$445=I2))"

The line works ok in its current state. What am I doing wrong?
Regards - Dave.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Continuation of a macro	Dan Wood	Excel Discussion (Misc queries)	2	December 20th 09 11:54 AM
Line Continuation issue	Bishop	Excel Worksheet Functions	6	May 21st 09 01:47 PM
Line continuation.	Dave	Excel Programming	1	February 9th 09 03:40 PM
Line Continuation in combination chart	CB	Charts and Charting in Excel	2	June 24th 08 07:34 PM
Line continuation error	Todd Huttenstine	Excel Programming	4	July 29th 04 05:16 AM

All times are GMT +1. The time now is 09:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us