Modify macro to remove formulas

Hello everyone,

I need your help with modifying the below macro (I believe, I got this from excel forum only).

This macro actually creates new sheet based on an existing sheet called as "Template" and it also renames the newly created sheet with the record name which are found in "Unique IP" list.
For example, if Unique IP" sheet has 10 record names (a, b, & c), macro creates 10 new sheets identical to "Template" sheet and re-names those 10 sheets with respective record names (a, b, c etc ) found in Unique IP list.

This code works perfectly, however, the macro is taking a very long time to run when there are 100 sheets in question. (P.S - "Temaplate" sheets has lot of formulas, and the same formulas will be copied to the new sheets when they are created for each record). This is making excel very slow

What I want is, to have macro create sheets in interval
- Should only create 10 records at a time and once formulas have populated results convert everything/formulas on these new sheets into values (copy paste special as values).
- Once the above is done, proceed with the next 10 records.
- The macro should stop once the sheets are created for all the records in "Unique IP" list


Here is the macro that I'm using so far

Please Login or Register  to view this content.

Thanks in advance!
Prithvi

This will change each sheet to "values" as it goes:

Please Login or Register  to view this content.

Glad to help. I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above and mark this thread as SOLVED. Thanks.