Select Range Question

[Calvin De Beverly]

I am sure I doing something simple to make this error out but I just can't see it. I followed examples but no joy? See the comment in the code for the question; thanks.

Sub MySelection()
Dim MyData As Range
Set MyData = Range("A1:D5")

' Why does the next line error out "Run-Time error 1004
'    (Method range of global object failed)

Range("MyData").Select

'While the next line's direct reference to the range does work?

Range("A1:D5").Select
End Sub

[mc84excel]

Try this.

Sub MySelection()
Dim MyData As Range
Set MyData = Range("A1:D5")
MyData.Select
End Sub

[Calvin De Beverly]

Thank you so very much that did it and I understand what I did wrong now.

[jolivanes]

Instead of

Set MyData = Range("A1:D5")

use

Range("A1:D5").Name = "MyData"

Too late I guess.
From what I see is that one names a range and mine creates a named range.