Sum Function
Posted by C Tucker on September 07, 2000 9:30 AM
Can someone provide me with the VB code for the SUM Function?
Posted by AB on September 07, 0100 11:20 AM
Set fn = Application.WorksheetFunction
Set SumRange = Range("A1:A50")
fn.Sum (SumRange)
Posted by C Tucker on September 07, 0100 12:02 PM
Thank you for your quick response but what I'm trying to do is write a User Defined Function, not call a Worksheet Function within a procedure. I think that the SUM Function script would be a good point of reference. Any suggestions?
Posted by C Tucker on September 09, 0100 7:56 PM
Thank you for the reference. You should minimally receive a thank you from from Mr. Walkenbach, if not a commission.
Posted by Celia on September 07, 0100 7:56 PM
Pages 630-633 of John Walkenbach's book "Excel 2000 Formulas" provides the code for a function that emulates the SUM function.
Celia
