PANKAJUTEKAR
Board Regular
- Joined
- Jun 10, 2011
- Messages
- 79
Dear All,
In Aftrenoon, Mr. Sektor Sir has given me the following code for cells addition containing string values.
but this code i have not understand.
I wrote this code in vba workbook.
what he has suggested me, in workbook, in cell c115 (here i want total),
put formula as "=SumKW(c7,c112)"
But i am not getting how this "SumKW" function will work after i wrote in cell 115.
Please All, make me understand this query.
This is very imp for me to solve my problem.
In Aftrenoon, Mr. Sektor Sir has given me the following code for cells addition containing string values.
but this code i have not understand.
Function SumKW(ParamArray arr() As Variant) As Double
Application.Volatile
Dim i As Integer, res As Double
Dim cell As Range
For i = LBound(arr) To UBound(arr)
For Each cell In arr(cell)
res = res + Left(cell, Len(cell) - 2)
Next
Next
SumKW = res
End Function
I wrote this code in vba workbook.
what he has suggested me, in workbook, in cell c115 (here i want total),
put formula as "=SumKW(c7,c112)"
But i am not getting how this "SumKW" function will work after i wrote in cell 115.
Please All, make me understand this query.
This is very imp for me to solve my problem.