Method Range of Object Global failed
May 2, 2012 3:49 AM Subscribe
I'm starting to write some Excel-VBA Macros, but it seems I don't get some basic things. I tried this simple code:
posted by SweetLiesOfBokonon to Computers & Internet (4 answers total) 3 users marked this as a favorite
Dim MyRange As Range
Set MyRange = Worksheets("Sheet1").Range("A1")
It displays the content of the cell and copies it with MyRange.Copy, however if I use Range("MyRange").Copy instead I get a Method Range of Object Global failed. Why is this so?