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 » Excel Worksheet Functions
Excel Worksheet Functions
Resolved · Low Priority · Version 2003
Fri 27 Mar 2009, 16:22Delegate Robert said...
Robert has attended:
Excel VBA Advanced course
Excel Worksheet Functions
Can you use Excel functions within your VCBA code?
Thu 16 Apr 2009, 11:00Trainer Carlos said...
RE: Excel Worksheet Functions
Hi Robert
Sorry for the delay in responding.
I guess you mean VBA rather than VCBA which is not a programing language
The simple answer is yes you can use Worksheet functions in VBA.
The code is as follows:
Application.WorksheetFunction.<The Function>
This brings up a list of functions that can be used in VBA. For Example:
Application.WorksheetFunction.Sum(Range(Cells(10, 8), Cells(36, 8)))
which sums the numbers in column 8 from rows 10 to 36
Hopes this helps
Carlos
Wed 22 Apr 2009: 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:Select Single Data MarkerTo select a single data marker in a chart, ie line, bar or column; |
