Hello Dear
You can access excel function from vba code.
here is the example
Syntax : ActiveCell.FormulaR1C1 = "=Here your function,What you want to Access"
Example
ActiveCell.FormulaR1C1 = "=SUM(R[1]C[1],R[2]C[1],R[3]C[1],R[4]C[1],R[5]C[1])"
Hope it Will Help
Happy to Help
:)
Shyam
On T
Hello,
I am able to use these functions in the worksheet itself, but not able
to use them in a VBA macro in the same. I get an error that Object
doesn't support this property or method. This method, however, seems
to work on Excel2007. Does Excel2003 not support using this from VBA ?
Is there any
