formula turning my copy page into text

[chriswrcg]

I have a macro that copies data off a page and paste it onto another page. The problem I am having is the code seems to turn the page that was copied into all text cells and erases the formulas I have active on the page. I have been over the code but I can't see where the fault is causing this. The code should only copy the page and paste as text leaving the original pages formulas intact. I need more eyes to find the problem.

Please Login or Register  to view this content.

[davesexcel]

You have cells.select:selection.copy:pastespecial xlPasteValues.

Those lines of code are changing your cells to values.

[xlnitwit]

Hi,

Your code is copy and pasting the same selection. Perhaps this

Please Login or Register  to view this content.