Compile error when trying to Copy from one sheet to another sheet

[cartica]

Hi-

I am receiving a compile error when I am trying to insert below code in between my other code. I am sure it is something simple I need to add. Any suggestions.

Thanks

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Change this:

Please Login or Register  to view this content.

To this:

Please Login or Register  to view this content.

[cartica]

that works. thank you

[xlbiznes]

try this,

Please Login or Register  to view this content.

[AB33]

OR

Please Login or Register  to view this content.