In excel 2000, is there an evaluate-function or
equivalence of subroutine in VBA to do the following:
function myadd(a#, b#)
myadd = a + b
end function
sub test
msgbox EVALUATE("myadd( " & 2.3 & ", " & 2.3 & "
"
end sub
If impossible directly, please share thoughts on alternatives.
thanks, Yu
ps: I need myadd to update multiple cells in multiple sheets; this will permit me to invoke "myadd" from formulas.
equivalence of subroutine in VBA to do the following:
function myadd(a#, b#)
myadd = a + b
end function
sub test
msgbox EVALUATE("myadd( " & 2.3 & ", " & 2.3 & "
end sub
If impossible directly, please share thoughts on alternatives.
thanks, Yu
ps: I need myadd to update multiple cells in multiple sheets; this will permit me to invoke "myadd" from formulas.