All,

Following formula gives me an application defined or object defined error:

ActiveCell.FormulaR1C1 = "=min(R" & rowr & "C" & week2locform & ":R" & rowr & "C)"

whereby rowr = 2 (will not change)
week2locform = -10 (will change)
The Column on the end is correct at being assigned to 0- i.e. the end of the min formulae is in a cell 2 rows above but in the same column.

Any help would be much appreciated...

Thanks
Inderpal