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

--
Message posted from http://www.ExcelForum.com

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)

"banavas " wrote in message
...
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 form
like

rL.Columns(i).sum()

Thanks!
G.


---
Message posted from http://www.ExcelForum.com/