Run-Time Error 438

[jomili]

I'm getting a "Object doesn't support this property or method" error on the below line of code:

Please Login or Register  to view this content.

The scenario is I'm copying a column from on sheet, and want to paste it on another, to the right of the other columns already there. The code worked fine last week, now here we are a week later, no other changes, and it throws up an error. Any help on this would be greatly appreciated.

Here's more of the pertinent code:

Please Login or Register  to view this content.

[Colin Legg]

Hi,

A range doesn't have a paste method which is why you get the error.

Here's one alternative:

Please Login or Register  to view this content.

[jomili]

Colin,

That did the trick just right. Thank you very much.

On the "Range doesn't have a paste method", why did the code right before my bad code work? It's identical in structure, other than having a range of cells to copy/paste rather than a single cell, plus being a pastespecial.

[Colin Legg]

Hi,

On the "Range doesn't have a paste method", why did the code right before my bad code work?

Right before it is Range.PasteSpecial rather than Range.Paste

Please Login or Register  to view this content.

[jomili]

So, I guess "Paste" is a completely different animal than "PasteSpecial", at least as far as the "Range" property is concerned?

[Colin Legg]

Yes, exactly - if you like you could say that Range's can't Paste.

Other things can Paste - for example, a Worksheet - but not a Range.

[jomili]

Thanks Colin; those are the types of things that are REALLY valuable to learn. I appreciate the help.

Thanks,
John