rootdown42
Board Regular
- Joined
- Jun 8, 2005
- Messages
- 93
I'm really pulling my hair out on this, cause this shouldn't be difficult.
I have two sheets, a "Data" and "Display" sheet. I'm simply trying to copy the data from "Data" to "Display". When I get to the following code:
I get a runtime error 1004 - information can't be pasted because copy and paste area are not the same size/shape. Doesn't VBA know that Cells(7, 2) is only the top-right cell of the range I'm trying to paste? I can't define the size of the paste range because the copy range size is going to be different every time. I swear I've done this before without issue. Is this error really caused by range-size issues, or could it have a problem with switching from one sheet to another?
This project is due to my boss tomorrow, and I'm going to look really dumb if this is why I can't deliver. Any help is most appreciated.
I have two sheets, a "Data" and "Display" sheet. I'm simply trying to copy the data from "Data" to "Display". When I get to the following code:
Code:
shtData.Range("A2", Range("A2").End(xlDown).End(xlToRight).Address).Copy _
Destination:=shtDisplay.Cells(7, 2)
This project is due to my boss tomorrow, and I'm going to look really dumb if this is why I can't deliver. Any help is most appreciated.