Copying column within With statement

[bd528]

I'm trying to copy a column from one sheet to another within a With. I was hoping the below would work, but I get Runtime Error 424 Object Required error message.

Please Login or Register  to view this content.

Any ideas what I'm doing wrong?

Thanks

[teylyn]

bd, please wrap your code in code tags, however short the snippet may be.

[bd528]

Figured it out - I hadnt defined shtemp2.

Cheers!

[teylyn]

Thanks for
- wrapping your code in tags
- coming back to share your solution
- bothering to mark the thread closed.

Please post more often!