With Statement Questions

Hi everybody,

I have two (2) questions.

1.
Can you copy a range within one "With" statement and paste it in another "With" statement immediately following the first? I've tried and "CutCopyMode" seems to turn off when the first "With" statement is ended.

2.
The following code was originally written to run outside a "With" statement. I have placed it in a "With" statement but I know the syntax is wrong on several lines. Can anybody give me the correct syntax?

Please Login or Register  to view this content.

royUK,

Sorry it was 1:30am and brain fade/frustration had set in.
I'm new to VBA which doesn't help either.
Hopefully this will give you a clearer picture.

Please Login or Register  to view this content.