Inserting a row will not automatically copy a formula, you must do this
explicitly so for example:

You insert a new row at row 5, then use the autofill

Rows("5:5").Insert Shift:=xlDown
Range("F4").AutoFill Destination:=Range("F4:F5"), Type:=xlFillDefault

Cheers
Nigel

"RONALD" wrote in message
...
I am trying to find a way to insert a row between a column with formulas
ie f1:f6 the formunal go down top to bottom I am trying to insert a row at 5
the row goes in with no problem but the formula does follow done I end up
with a black cell
please help