Copying formula result to new cell, without copying formula itself

I've included my excel as its hard for me to explain it without referring to an example, so please download sheet.

You'll see I have a button named " New > Original, Delete Measurements". Right now, that button runs a macro that deletes cells D18, D30, I18, I30.

I would also like it to take the results that are in G4 and G5, and put them in C4 and C5. But only the results, not the formulas themselves. But the results in G4 and G5 are based on the data that is in D18,D30,I18,I30, which the macro is deleting. So I just want to copy the formulas results to other cells before I delete the cells that the formula is using to get its results.


To simply it,

A1: 2
A2: 3
A3: =A1+A2 (which would be 5)

I am looking to first have excel copy the result, 5, to cell B1; then delete the data in cells A1 and A2 (which would then make A3 a 0 again, but Id have the old result, 5, in B1.)

Hi NappyJim,

Record your macro again and when you copy do a "Paste Values Only" to the cells you want. When you do this it doesn't use any of the formulas. Then when you Delete2 the values copied will stay.

A great way to learn VBA is to record macros and then look to see what VBA looks like for the keystrokes you recorded.