using range name in Find

Hi All,

I have a range named OMSZ, and I'd like to use this name in Find, but this
line gives an error:
MyVar = ThisWorkbook.Names("OMSZ").Find("StringToSearchFor", [A1], , ,
xlByRows, xlNext).Row
What is the correct syntax?
The named range is OK, because e.g.
MyRange = ThisWorkbook.Names("OMSZ").RefersTo
gives back the correct range.

..Find is a method of a Range object. Try either Range("OMSZ").Find or
Range(MyRange).Find.
Mike F
"Stefi" <[email protected]> wrote in message
news:[email protected]...
> Hi All,
>
> I have a range named OMSZ, and I'd like to use this name in Find, but this
> line gives an error:
> MyVar = ThisWorkbook.Names("OMSZ").Find("StringToSearchFor", [A1], , ,
> xlByRows, xlNext).Row
> What is the correct syntax?
> The named range is OK, because e.g.
> MyRange = ThisWorkbook.Names("OMSZ").RefersTo
> gives back the correct range.

Thanks Mike,
having made some experiments I found this form working:
MyVar = ThisWorkbook.Names("OMSZ").RefersToRange.Find("StringToSearchFor",
[A1], , , xlByRows, xlNext).Row

Is there a simpler one?

Regards,
Stefi

„Mike Fogleman” ezt �*rta:

> ..Find is a method of a Range object. Try either Range("OMSZ").Find or
> Range(MyRange).Find.
> Mike F
> "Stefi" <[email protected]> wrote in message
> news:[email protected]...
> > Hi All,
> >
> > I have a range named OMSZ, and I'd like to use this name in Find, but this
> > line gives an error:
> > MyVar = ThisWorkbook.Names("OMSZ").Find("StringToSearchFor", [A1], , ,
> > xlByRows, xlNext).Row
> > What is the correct syntax?
> > The named range is OK, because e.g.
> > MyRange = ThisWorkbook.Names("OMSZ").RefersTo
> > gives back the correct range.
>
>
>