Innany
06-09-2006, 08:07 AM
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?
=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?