Referring to a defined name in VBA

I have a subroutine in which I want to check to see if a variable ("NameA") is within a defined name ("ListA") within my workbook. "NameA" is defined within the VBA as a string. I get an error on the If statement stating "Method range of object Global failed"

Please Login or Register  to view this content.

So if the variable NameA can be found in ListA, then IsNumber will be True

How do I fix this?

Thanks

ChemistB

You can use Match, but this is what I'm accustomed to:

Please Login or Register  to view this content.

Hi,

The syntax for using an Excel application function in the VBE is:

Application.WorksheetFunction.Match(..........etc...), rather than just Application.Match(.....)

try including the missing 'WorksheetFunction' bit and see if that helps.

Rgds

Originally Posted by Richard

Application.WorksheetFunction.Match(..........etc...), rather than just Application.Match(.....)

That part will work either way, but using WorksheetFunction will allow Intellisense to work.

Thanks to all of you. I will play with the coding today.

ChemistB