Unclear Error Message

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Sub temp()
Dim MyRange As Range

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

is a possibility.
 
Back
Top