Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel Worksheet Functions

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Excel Worksheet Functions

Resolved · Low Priority · Version 2003

Reply 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?

For upcoming training course dates see: Pricing & availability

Reply 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.

Excel articles

· The Key Settings In Excel 2003's Options Panel
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips
· Experience The Power Of PowerPivot
· Save time with Microsoft Excel
· Excel 2010 - Is It Worth The Upgrade?

Please browse our web site to find out more about
excel-training-courses and other Microsoft training courses.

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips