Unclear Error Message
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" wrote in 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?
|