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
Bookmarks