Formulas

The UK's most regular instructor-led training courses.
Training information: course excel training vba london · Excel advanced · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Formulas

Simon has attended:
Excel VBA course

by - delegate Simon [1 post] (2008 Mar 13 Thu, 16:29) Reply

How do I imbed formulas into VBA macro code?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: Formulas

by - trainer Stephen gold contributer [394 posts] (2008 Mar 28 Fri, 09:30) Reply

Hi Simon

Thankyou for your question

I am assuming that you want to use the functions that come as standard with Excel

These functions are called worksheet functions, and are child objects of the application object. The following code uses the sum function to add up a given range of cells and insert it into cell b31

Range("b31").Value = Application.WorksheetFunction.Sum("B2:B30")

All the standard functions can be accessed in this way

Hope this is useful

Regards

Stephen