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/