Posted to microsoft.public.excel.programming

external usenet poster

Posts: 557

Sumproduct in Macro

Sub DD()
Dim c As Range
Lastcl = Cells(Rows.Count, "A").End(xlUp).Row
For Each c In Range("N2:N" & Lastcl).Cells
c.Value = WorksheetFunction.SumProduct(--(Range("M2:M" & Lastcl)), --
(Range("H2:H" & Lastcl)))
Next c
End Sub

above macro doesnt work please help

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
SUMPRODUCT macro	Kim	Excel Discussion (Misc queries)	2	September 21st 09 04:36 PM
SUMPRODUCT in macro	Office_Novice	Excel Programming	3	June 21st 08 01:50 AM
use LIKE within sumproduct in macro, possible?	[email protected]	Excel Programming	3	August 31st 06 02:42 AM
macro with SUMPRODUCT help	[email protected]	Excel Programming	8	August 30th 06 10:27 PM
How to use SUMPRODUCT in macro?	Tarek	Excel Programming	6	April 27th 05 07:03 AM

All times are GMT +1. The time now is 05:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us