Thu 13 May 2010, 10:57Delegate Maria said...
Maria has attended:
Excel VBA Intro Intermediate course
Functions
Can I use functions in the VBA coding ? Things like STDVAR, NPV etc... and does it work the same way in term of data input/setup?
Is there a list of maths functions somewhere I can use in my code?
Thanks.
M
Thu 13 May 2010, 11:20
Edited on Thu 13 May 2010, 11:21Trainer Stephen said...
RE: functions
Hi Maria
Thanks for your question
You can indeed use excel functions in your VBA coding. They are contained in the worksheetfunction object. You place the function's arguments in the normal way.
e.g.
worksheetfunction.Sum(Range("A1:A20"))Not all worksheet functions are available. You can find a complete list by typing "worksheetfunction object members" into vba's help tool.
Hope this helps
Regards
Stephen
