Using Spreadsheet Functions in VBA Code

Problem

You're writing a VBA function and want to call a built-in Excel function from within VBA code.

Solution

Use the WorksheetFunction object to gain access to Excel's functions from within VBA code. Read Recipe 2.13 for more information on the WorksheetFunction object.





Excel Scientific and Engineering Cookbook
Excel Scientific and Engineering Cookbook (Cookbooks (OReilly))
ISBN: 0596008791
EAN: 2147483647
Year: N/A
Pages: 206
Authors: David M Bourg
Simiral book on Amazon

Flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net