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