Unclear Error Message

[Guest]

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?

 

[Tom Ogilvy]

Sub temp()
Dim MyRange As Range

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

is a possibility.

 

[Guest]

thanks!

Sub temp()
Dim MyRange As Range

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

is a possibility.