is there a way to paste by Value into the destination cells? I believe that as is, the code above defaults to 'normal' paste mode (which also pastes formats).
How about formulas? Does the code shown above paste formulas behind cells in the source range into the destination range as well? Because I cannot afford for my code to paste formulas - I need the code to just paste by values, period!
Any help greatly appreciated. Thanks