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

course excel in london - excel functions within code

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

ResolvedVersion 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:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.