Code for coping a whole row from one sheet to another

Hi I have a code:

Please Login or Register  to view this content.

It copies a cell from sheet 1 into a cell in sheet 2, however I need it to copy the whole row (and place it into the appropriate columns (the columns match the first sheet)). What should I change?

Thank you for your help

Moderators note: code tags added for you - this time

Please Login or Register  to view this content.

Hi, sunshne900,

instead of setting the range to the cells in Column I

Please Login or Register  to view this content.

try using this line

Please Login or Register  to view this content.

If 152 is not a variable but the row up to which should be used you may write the code like

Please Login or Register  to view this content.

Please mind that a whole row should be inserted starting at Column A in the target sheet.

Ciao,
Holger

Hi, sunshne900,

if you want to copy a known number of Columns code may look like this

Please Login or Register  to view this content.

to cover the range between A3 and I152.

Ciao,
Holger

Hi, sunshne900,

maybe like this:

Please Login or Register  to view this content.

Building 2 arrays holding the columns from which to copy and where to put the data.

Ciao,
Holger

Hi, sunshne900,

The info I am trying to copy is filtered

Please Login or Register  to view this content.

If you change the code you use it would be nice if you post the altered code as well.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The original thread title was about copying a whole row - I think that has been solved?

Ciao,
Holger

Hi, sunshne900,

thanks for the feedback and the rep - do you mind marking the thread as Solved via Thread Tools over the first post?

Ciao,
Holger