How to copy entire row to a different sheet staring from second column

[gregorolaf]

Hi All,

Could you please help me with the below, I can copy the row and paste it but only staring from first column in the new sheet.

Is there any other way to start pasting from, let's say the second column

THe code excerpt:

Please Login or Register  to view this content.

Thanks for help
Gregor Olaf

[HaHoBe]

Hi, Gregor Olaf ,

please use code-tags when displaying the procedures.

You canīt copy a row to start pasting in any other column but A (short on cells for that row to fit in) but yoiuz may restruct the range to be just the used range like

Please Login or Register  to view this content.

Donīt forget to add to curr_position.

Ciao,
Holger

[gregorolaf]

Perfect Thanks Holger

[HaHoBe]

Hi, Gregor Olaf,

glad that I could help but please do me a favour and add code-tags around the procdure in the opening post as requested by the Forum Rules.

Use [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] for entering code manually.

For changing existing code: edit the post, highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Ciao,
Holger

[gregorolaf]

Done. Thanks Holger