Match & Index Functions

[Innany]

I have a named range called AppServers. I tried to use Match function from a cell and it worked np:

=MATCH("arl-500eb-auth1",AppServers) returned 1, which is the first cell

if I try to do the same from VB it returns nothing:

a = WorksheetFunction.Match (c, Range(AppServers))

I also tried the Index function, and I have no luck with that one either, although it works from a cell.

Any ideas?

[mdmackillop]

Try Range("AppServers") You need quotes round a Range Name for this use.

[Innany]

Thank you, I thought I tried that, but I think I put"" around c instead.