Copy a range based on a filtered (drop-down list)

That code worked with my original code (naming the range A2:A200), but with the "offset" code I get the "copy and paste area not the same size and shape" error, with the "Sheets......PasteAll" line highlighted.

Frustrating, when I know it should work, but doesn't. Of course, it does if I name the range, but that's just not very elegant.

Hmmm..

Are you able to upload your workbook for us to look at, or can you make a version that you can share with us where you can repro the issue? Might be easier to debug.

Ken Puls said:

Hmmm..

Are you able to upload your workbook for us to look at, or can you make a version that you can share with us where you can repro the issue? Might be easier to debug.

Click to expand...

Yes, I was thinking that also. I'll work on it this weekend and see what I can come up with. Thanks!