Paste VALUES...not FORMULAS

[HuskerBronco]

I have VBA code in my workbook that looks like this:

Please Login or Register  to view this content.

The problem with this code is that each range is copying FORMULAS rather than VALUES into the destination cells. What do I need to add to the code to circumvent this behavior...and have the code paste ONLY VALUES into the destination cells?

[Norie]

Try this.

Please Login or Register  to view this content.

[HuskerBronco]

Holy crap...!!! Norie....!!!!

That was AWESOME....!!!!

Not only did you fix my Sub Routine for me...but you showed me how to reduce the amount of code to nearly nothing....!!! The procedure ran a THOUSAND times quicker....!!!! Thanks, a lot, for your excellent feedback....!!!