That means the value wasn't found.

Look closely at your posting. the two things you are comparing are not
equal

?SheetEXcludeArray (0,1)
Advanced Output

?sh.Name
Advanced Ouptut

"Advanced Ouptut" < "Advanced Output"

--
Regards,
Tom Ogilvy


"ExcelMonkey" wrote in message
m...
I am trying to do a Vlookup on a 2D VBA array that I created. The
array named SheetExcludeArray has been defined as a Public variable.
I have loaded sheet names into the first column of the array and
values in the other column. Later on in my routine, I want to
retrieve the values in the second column. As follows:

Sheet 1 1
Advanced Ouput 1
Sheet 3 0

I am gettng a 1004 Error stating "Unable to get Vlookp property of the
Worksheet Function".

The line of code I am using is:
Application.WorksheetFunction.Vlookup(sh.Name,Shee tExcludeArray,2,0)

However when I go to the Immediate Window I get this:

?SheetEXcludeArray (0,1)
Advanced Output

? SheetEXcludeArray (1,1)
1

?sh.Name
Advanced Ouptut

What doest the 1004 error imply? My immediate window tells me the
array has values in it and that my variable has a sheet name passed to
it. What could be wrong here?

Thanks