.formula in all the cells of a given column but the 5 first

[jigglypuff]

Hi guys I am still having problems with the .formula function, I have tried to set a function via VBA in all a column of cells without any success, here's the code I am trying to use

Cells(Target.Row, 7).Formula = "=if(C:C="""","""",Sheet4!$D$32*C:C)"

But I need that the first 5 cells of column 5 remain without any formula inside. Is it possible? I always get some error trying to do it..

 

[jigglypuff]

If Target.Column = 3 Then Cells(Target.Row, 7).Formula = "=if(C:C="""","""",Sheet4!$D$32*C:C)"

now I changed the code to the above one, but still looking for the ideal one. any ideas?