Unclear Error Message

Hi,
I am trying to set a range variable with a defined range, but I get this
error all the time:
"Run-time error '1004':
Application-defined or object-definned error."

the code is this:
Sub temp()
Dim MyRange As Range

Set MyRange = Names("temp").RefersToRange
..
..
..
End Sub

I can't figure it out. Can you help?

Sub temp()
Dim MyRange As Range

Set MyRange = ThisWorkbook.Names("temp").RefersToRange
..
..
..
End Sub

is a possibility.

--
Regards,
Tom Ogilvy


"Yossi" <[email protected]> wrote in message
news:[email protected]...
> Hi,
> I am trying to set a range variable with a defined range, but I get this
> error all the time:
> "Run-time error '1004':
> Application-defined or object-definned error."
>
> the code is this:
> Sub temp()
> Dim MyRange As Range
>
> Set MyRange = Names("temp").RefersToRange
> .
> .
> .
> End Sub
>
> I can't figure it out. Can you help?

thanks!

"Tom Ogilvy" wrote:

> Sub temp()
> Dim MyRange As Range
>
> Set MyRange = ThisWorkbook.Names("temp").RefersToRange
> ..
> ..
> ..
> End Sub
>
> is a possibility.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Yossi" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> > I am trying to set a range variable with a defined range, but I get this
> > error all the time:
> > "Run-time error '1004':
> > Application-defined or object-definned error."
> >
> > the code is this:
> > Sub temp()
> > Dim MyRange As Range
> >
> > Set MyRange = Names("temp").RefersToRange
> > .
> > .
> > .
> > End Sub
> >
> > I can't figure it out. Can you help?
>
>
>