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:

Please Login or Register  to view this content.

"

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

Please Login or Register  to view this content.