Paste Data under header with same name

[mtilbury]

Hi The below code is working for me, however on the first Loop in Column A when I paste it overwrites the column heading, but every column after that it pastes the data below the heading. Why is the first column different?

Is the Paste section of my code incorrect? Can it be done better? Its the code under 'Paste header that is causing the trouble?

Please Login or Register  to view this content.

[Kaper]

No attached file, so not tested.
Try pasting to first (and following) cell(s), not to strictly (byt may be not perfectly well) defined range

Please Login or Register  to view this content.

instead of:

Please Login or Register  to view this content.

you may also (on testing and dev. stage) add checking what opasting address you really select by msgbox, say:

Please Login or Register  to view this content.

[mtilbury]

Perfect. Cheers Kaper.