Pasting to a destination

[RicksAtWork]

I have copied a range and now want to paste it to a new sheet.

Usually I do:

countryWorkSheet.Paste

But I know want to the data to be pasted to a specific row

I think I need to use the destination attribute.

How is this done?

 

[xlbo]

You need to select a RANGE to paste to

As a starter for 10, try recording yourself doing this using the MacroRecorder...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question