Ed,

You can call most worksheet functions from VBA with code like

Result = Application.WorksheetFunction.VLookup(....)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Ed Bitzer" wrote in message
...
I suspect, since not in the help file, that the VLookup function
is not
available with a macro - true?
I am fairly new to Excel macos but not VBA under Access and was
writing
one to grab the sheet name, Jan, Feb, Mar etc, determine the
prior month
using VLookup and small table on a summary sheet, and then
building cell
formula's which needed the prior month sheet. If I had used
full names
of January, February I could use month number and then subtract
and then
convert back. With abbreviation almost looks like I need to
lean how to
"seek" as I use to do in Access. Appreciate if somebody would
just give
me a push in the right direction.

Ed