Copy between (2) active Worksheets

**clemsoncooz** · 02-17-2012, 05:24 PM

Still new to this, so sorry for not knowing.

Why does something this simple fail?

Please Login or Register  to view this content.

RunTime Error '438':
Object doesnt support this property or method.

**john55** · 02-17-2012, 05:34 PM

hi,
try this

Please Login or Register  to view this content.

**clemsoncooz** · 02-17-2012, 05:39 PM

Thanks john55.

I have the solution and I know this works.

Please Login or Register  to view this content.

But I was more curious as to why this below doesnt as I have been instruction on previous occasions to NOT select items:

Please Login or Register  to view this content.

Selecting the range first and then having a second line of code to paste it works - I was just wondering why the (2) lines of code doesnt work.

**john55** · 02-17-2012, 06:02 PM

I do not see why you want to use it...but it's yr choice!

Please Login or Register  to view this content.

Re: Copy between (2) active Worksheets