Help with Copy and Paste VBA

[ktschoof]

Hello Everyone,

I am working on the script below so I can copy information from one table to another in the same workbook. I works but the problem I am running into is that I have formulas in the cells and I need to paste special. However, the pastespecial command isn't working...

This works but pastes the formula...

Please Login or Register  to view this content.

But this doesn't

Please Login or Register  to view this content.

[Artik]

Please edit your post and enclose the code in

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Artik

[ktschoof]

Thanks so much. So It was just an _.

[Artik]

It seems to me that while editing your first post, you modified the first code incorrectly. It should be:

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

In the second version of your code, the carry-over to a new line cannot appear. These must be two separate lines of code.

Artik