hello mr. excel users,
just trying to create a simple add function but below code is missing
Public Function myAdd(num1 As Range) As Long
Dim temp_total As Range
Dim final_total As Long
For Each temp_total In num1
If IsNumeric(temp_total.Value) = False Then ((("MISSING CODE"))
GoTo nextloop
End If
final_total = final_total + temp_total.Value
Next temp_total
myAdd = final_total
End Function
above red font, should do Next temp_total, how could it work?
thanks!
just trying to create a simple add function but below code is missing
Public Function myAdd(num1 As Range) As Long
Dim temp_total As Range
Dim final_total As Long
For Each temp_total In num1
If IsNumeric(temp_total.Value) = False Then ((("MISSING CODE"))
GoTo nextloop
End If
final_total = final_total + temp_total.Value
Next temp_total
myAdd = final_total
End Function
above red font, should do Next temp_total, how could it work?
thanks!