Cleaning up the code after recording a macro.

The following is an iimprovement. But I can not figure out the code to paste special values only. so instead I am using: .paste.

Please Login or Register  to view this content.

I attempted the following improvement, and run into an error at Range("A1").Paste

Please Login or Register  to view this content.

It seems I am following up by myself, but I am trying to leverage off of help, from other posts. I now have an error at the second "With ActiveSheet" at the .Paste. Any help would be appreciated.

Please Login or Register  to view this content.

Whilst the code above mat supercede your question
Application.CutCopyMode = False stops the copy above it being remembered, so when it comes to paste later, there is nothing to paste

Regards

Dav

Your code did not run. It looks very professional however. Thanks. Perhaps it's best to start over. Here it is:

1. We are copying a range [A1:Z50000] from the "105_12_31_2009" worksheet in the 105_Report_Spreadsheet workbook.

2. And then pasting it onto a range [A1:Z50000] onto the "Formulas" worksheet in the Formulas workbook. We then update the formulas on the "Formulas" worksheet. Copy the entire worksheet.

3. We then create a new workbook = 105_Report_Spreadsheet_Values and rename sheet1 to 105_12_31_2009_values, and paste special values onto that sheet.

4.We then "go back" and clear the contents which was pasted onto the Formulas worksheet in the Formulas workbook.

5. Save all files and close them.

I appreciate all the help. There is a method to this madness.

if it is only the pastespecial bit that is defeating you, you can record the code through a keystroke macros

it is something like

Please Login or Register  to view this content.

Regards

Dav

I figured out a way. It's incredibly ugly...but it works. Thanks for all the help.

Please Login or Register  to view this content.