Hi Experts,
I have done this using Indirect(), Can you please help with UDF.
I waiting for your valuable reply
Regards,
Amol J
On Sunday, August 19, 2012 2:46:36 PM UTC+5:30, Amol J wrote:
> Hi All,
>
> Please help me with this problem. its related to range reference . When we
> dra
Hi All,
Please help me with this problem. its related to range reference . When we
drag any formula into columns. it adjust cell accordingly and increase the
columns. but what i want is If i drag sum udf into columns it will increase
columns as well as rows
On Saturday, August 18, 2012 9:
Dear Amol,
Please Try it.*
Function Udf_sum(rng As Excel.Range)
Dim cell As Range
For Each cell In rng
If VBA.IsNumeric(cell) And cell.Value <> "" Then
Udf_sum = Udf_sum + cell
End If
Next cell
End Function
*
On Fri, Aug 17, 2012 at 11:32 AM, Amol J wrote:
> Hi experts, I need your help, I tr
Hi experts, I need your help, I tried myself but unfortunatly its not
working.
I need UDF to sum range.
1) first my range will be B4:E4 and
I am going to drag udf into columns to next range will be C5:E5,
Means when I will drag my udf function it will increase in range by
1column and 1 row
Hi experts, I need your help, I tried myself but unfortunatly its not
working.
I need UDF to sum range.
1) first my range will be B4:E4 and
I am going to drag udf into columns to next range will be C5:E5,
Means when I will drag my udf function it will increase in range by
1column and 1 row
