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,

Omar,
You are missing one important word:

Public Function Sel_Len(Cell_Ref As Range) As Integer

NickHK

"Omer" <(E-Mail Removed)> wrote in message
news:CA476F99-35EE-4411-91AA-(E-Mail Removed)...
> 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,
>