Not sure that the following is really the answer you require.

Firstly my example uses the comma (,) as a delimiter in the formula so I am
not sure if the semi colon (;) is causing you a problem or perhaps you use
that in your country of origin.

When you want to use a formula with relative addressing then you need to
code the formula in the first cell then the next line of code copies that
cell to the remaining cells something like the following.

Range("A3").Formula = "=IF(A2<B2,A2,B2)"
Range("A3").Copy Destination:=Range("A3:AH3")

If this does not answer your question then perhaps you can supply a little
mor explanation with an example of your data.

Regards,

OssieMac