Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Function like Sum()
Dear All,
Has anyone ever create function like sum() which have parameter in range? What's parameter type should be used? Thanks for the help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Function like Sum()
Public Function MySum(rng as Range) as Double
Dim tot as Double Dim cell as Range for each cell in rng if isnumeric(cell) then tot = tot + cell.Value end if MySum = Tot End Function Would be a simple implementation. The correct answer depends on exactly what you want the function to be able to do. -- Regards, Tom Ogilvy "Yap Michael" wrote in message ... Dear All, Has anyone ever create function like sum() which have parameter in range? What's parameter type should be used? Thanks for the help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create function to look up the value | Excel Discussion (Misc queries) | |||
not sure how to create this function | Excel Worksheet Functions | |||
how to create function | Excel Worksheet Functions | |||
How to create a function | Excel Worksheet Functions | |||
How do I create a function into function list? | Excel Programming |