We recently found that the CopyValue function in range does not replace fomular with value when source and target are the same.
The code to repro is:
targetRange.CopyValue(sourceRange) I have attached a example file. If you cound point source and target range to A1:D9 in DailyRate worksheet, and run the repro code and save the file, when you open the file again, you will find the formulas are still there.
As I understand, copy value means the target range will be rewrite with the values of source range. Do you consider this one as a bug?