Copy and Paste values but not formulas

[Samhill62]

I have a spreadsheet that has two columns of formulas and following a change to certain other cells within the worksheet, return a prescribed value.
I am looking for some vba code that will automatically freeze the calculated data in the cells without affecting any of the other formula when the workbook is closed.
Does anyone have any similar code they may be able to share please?

 

[Samhill62]

It works for me so I don't know what else is happening on your sheet.

It copies and pastes he values I need perfectly, however the formulas in the empty cells below are being wiped out, which I do not want.

 

[Herakles]

Do the formulas in A101 downwards depend on the cells A1:A100?

 

[Samhill62]

Do the formulas in A101 downwards depend on the cells A1:A100?

No. Not all of the cells are being used in the column A1:A100. That is just a range that is populated with the formulas. As time goes on, the cells are gradually being populated with the week number and so next week the cells already populated will suddenly become the next week number which is not what is desired. The VBA copy and paste is to prevent this from happening.