Record Macro to Copy & Paste as Values - paste into cells that might move up/down as rows above are added/deleted

[momentumons]

Hello! Can you help?

This should be simple, right?

I have two cells (eg. AC58 & AC59) with a % number in each. I need to copy & paste these numbers into the cells next to them (AD58 & AD59) - this is so I can re-use these numbers without creating a circular reference.

When I do a simple 'record macro' of copy & paste-as-values this works UNTIL I add/delete rows above... then it always copies and pastes the exact same cells instead of moving with the spreadsheet. How can I copy/paste these numbers when they move up/down.

Does that make sense? Thanks

 

[momentumons]

Sub REFRESH()
'
' REFRESH Macro
'

'
    Range("AD58").Select
    Selection.ClearContents
    Range("AD59").Select
    Selection.ClearContents
    Range("AC58:AC59").Select
    Selection.Copy
    Range("AD58:AD59").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Application.CutCopyMode = False
End Sub

 

[momentumons]

Hello! Can anyone help me?

 

[momentumons]

If anyone finds this thread - I found a solution by using Named Ranges