9tanstaafl9
Well-known Member
- Joined
- Mar 23, 2008
- Messages
- 535
Hey, sorry to bother you for something that's probably obvious, but it's so obvious I can't seem to find the answer by searching...
I am trying to copy a range form one worksheet and paste it into another. Most of the time it works, but every once in a while I get a 1004 error saying that the areas are not the same size and shape so I can't paste.
I can't figure out why, since I am pasting the range to a only the top left cell, and I thought that was always ok. What's up?
Sheets("Phases").Range("B2").Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.Copy Destination:=Sheets("summary").Range("A4")
And, yes I know there are too many selects in the above code, but I don't know how to fix it...
Thanks again for any suggestions! I'd understand if it never worked, but when it usually works, it doesn't make sense.
Thanks!
I am trying to copy a range form one worksheet and paste it into another. Most of the time it works, but every once in a while I get a 1004 error saying that the areas are not the same size and shape so I can't paste.
I can't figure out why, since I am pasting the range to a only the top left cell, and I thought that was always ok. What's up?
Sheets("Phases").Range("B2").Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.Copy Destination:=Sheets("summary").Range("A4")
And, yes I know there are too many selects in the above code, but I don't know how to fix it...
Thanks again for any suggestions! I'd understand if it never worked, but when it usually works, it doesn't make sense.
Thanks!