Reference Current Cell in Formula

Hello,

I am trying to use a the value of current cell in my macro formula. It goes something like this:

Range("A2").End(xlToRight).Formula = "MIN(OFFSET(ActiveCell,0,-4):OFFSET(ActiveCell,0,-4)"

"

The First part Range("A2").End selects the last cell and with that cell I want to calculate the Minimums of the previous 52 cells. However, the current cell is set to change columns by 1 when I run the macro, so I cant just use the specific cell reference, e.g. OFFSET(EF2,0,1).

Any help would be greatly appreciated.

Sorry I forget a parantheses the real code is

Range("A2").End(xlToRight).Formula = "MIN(OFFSET(ActiveCell,0,-4):OFFSET(ActiveCell,0,-4))"