Copy & Paste Entire Range

Hello All,

I created this snippet of code to copy a column from sheet 2 and paste it into sheet 3. Sheet 2 column B has roughly 3015 rows (Minus Header), possibly more daily, I want to paste this into sheet 3 starting at A2, it keeps giving me an error. Any thoughts?

Please Login or Register  to view this content.

What error is this giving you? When I try and run this in my own test file it works without issue.

Try

Please Login or Register  to view this content.

You need to qualify all the ranges, not just the first one.

Or slightly simpler

Please Login or Register  to view this content.

Im getting Run time Error 1004. I am including a version of the test file I am working with.

That sheet has nothing in col B of sheet2

Column B is empty, maybe that's it. But once again, when I ran it, I didn't get any errors.

Originally Posted by Moragtao

when I ran it, I didn't get any errors.

That's probably because sheet2 was the active sheet. If any other sheet is active you will get an error.

Odd, really odd. All of a sudden it began to work...who knows.

Your code will work if Sheet2 is the active sheet, if it's not it will fail!
Did you see my suggestions in post#3?

Yup! Thats what I used.

Glad it works & thanks for the feedback