98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Functions
Functions
Resolved · Low Priority · Version 2003
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
Thu 20 May 2010: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Moving or Copying Sheets Between Workbooks in Excel 2010Here's how to move or copy sheets between workbooks in Excel 2010: |
