Hi,

I've recorded a macro that copies a formula, pastes the value of that formula into the column to the right of it, copies that, goes to the worksheet to the left, brings up the Goto dialogue box, and writes B"CTRL+V"

As you can see from the last line in this code, the last part doesn't work. It always goes to row 31, column C.

How can I change that?

    Selection.Copy
    ActiveCell.Offset(0, 1).Range("A1").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Application.CutCopyMode = False
    Selection.Copy
    ActiveSheet.Previous.Select
    Application.Goto Reference:="R31C1"