course excel in london - excel functions within code

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » course excel in london - Excel Functions within Code

course excel in london - Excel Functions within Code

resolvedResolved · Low Priority · Version Standard

James has attended:
Excel VBA Intro Intermediate course

Excel Functions within Code

Can you use Excel functions such as VLookup within code to get values (for example to assign the values returned to variables)?

RE: Excel Functions within Code

James

Yes you can

Carlos


 

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips


Server loaded in 0.09 secs.