ExcelBanter - View Single Post - Why Copy/Paste fails using Offset & Resize of myRange?

Dallman Ross

In ,
spake thusly:

Sheets("1200").Range("A" & myRow).Paste

The error is # 438 Object doesn't support this property or
method.

I'm just going to make a guess, based on a similar problem I
had recently. It could be that what I'm describing doesn't
apply to your situation. You'll tell us, I'm sure. :-)

It turns out that if there are array formulas present and
you copy a row, you can't paste it back over the same row.
(At least, this was so for me with Excel 2002.)

E.g., I copied Row 1 and tried to paste it to Rows 1-100
and got that same error. However, I was able to paste
to Rows 2-100. So that's how I got around the problem.

=dman=