Paste Special - Values Only

[dugar]

Working in one workbook, I am using sheet 1 as a master form and copying it to the back of the workbook and renaming it. Thx to some help here, the code below is working fine.

Please Login or Register  to view this content.

However, I am using data validation and a few formulas on sheet 1 and I do not want to copy these to the new sheet. I also need to restrict the copy and/or paste to Range A1:N58 from sheet 1. Seems I need a paste special inserted into the code to only paste the values. I think the paste code I need is below but I cannot get the placement right along with the range detail (A1:N58) that is needed. Thx for any help.

Please Login or Register  to view this content.

[modytrane]

Best way to learn how to create these macros is to record one and modify the macro as needed.
Here's a macro I just recoded with your requirements.
Try it, it's fun and it works.
Select Tools>Macro>Record New Macro.

modytrane

Please Login or Register  to view this content.

[T.J. Lanza]

One thing to keep in mind when starting from a recorded macro is that you don't actually need to use SELECT to act on something.

For example, the recorded macro can be condensed to:

Please Login or Register  to view this content.

Obviously, make sure the cleaned up code is still doing what you want it to, of course.

[dugar]

Many thx that did it! Sorry about the macro recorder - I should know better.