| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Sum Function
I want to create a custom function in VBA. The Function will take the
parameter as the sum formula in excel. How do I define parameter in VBA. The Sum function takes upto 30 arguments but I am interested in only one augument. I tried the following declarations: 1 Public Sel_Len(Cell_Ref as Range) as Integer 2 Public Sel_Len(Cell_Ref as String) as Integer I want to get the range cell address so that I can loop it for my calculation. Thanks & Regards, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom Sum Function
Omar,
You are missing one important word: Public Function Sel_Len(Cell_Ref As Range) As Integer NickHK "Omer" wrote in message ... I want to create a custom function in VBA. The Function will take the parameter as the sum formula in excel. How do I define parameter in VBA. The Sum function takes upto 30 arguments but I am interested in only one augument. I tried the following declarations: 1 Public Sel_Len(Cell_Ref as Range) as Integer 2 Public Sel_Len(Cell_Ref as String) as Integer I want to get the range cell address so that I can loop it for my calculation. Thanks & Regards, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert function - custom function name preceded by module name | Excel Programming | |||
| Custom Function: Detecting the cell the function is used in | Excel Programming | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| custom function - with built-in function | Excel Programming | |||
| Adding a custom function to the default excel function list | Excel Programming | |||
Linear Mode
