Copy columns to last row and paste in new sheet

[Gti182]

hi all,

having some trouble with below code.

Trying to copy ranges B:G & I:T (exclude column H) to last row and paste to new sheet.

The code works but when it paste's it includes column H data?

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[Gti182]

Hi John, yes thanks that works great.

Was hoping i could get away with just the 2 lines of code for the copy paste, is this not possible?

This works but don't understand why i get a different result when i bring in the LastRow portion in post #1.

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[Gti182]

thanks guys! John that works perfectly, just missed off the extra & ", " & bit in the copy line.

Cheers!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.