Modify Macro to Paste Values instead of formulas

I originally worked with dflak on the below code which has been perfect until I needed to add an INDEX formula to the shT Test worksheet in columns D, M, N. Upon running the "Save Today" macro, I receive a "Value Not Available" error in the above mentioned columns on ShH History worksheet. I need to paste values only. I have tried to modify the code on my own without any success. Any help would be appreciated. Thanks!

Please Login or Register  to view this content.