sum

[banavas]

Dear Friends,

I defined a variable rL as Range which contains x columns and y rows.
My task is to calculate the sum of column i. How do I do that in a for
like

rL.Columns(i).sum()

Thanks!
G

 

[Bob Phillips]

MsgBox WorksheetFunction.Sum(RL.Columns(i))


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)