INSTERING A ROW
 

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 cel
please help

INSTERING A ROW
 

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

INSTERING A ROW
 

Hi Ronald,
You will probably need to use OFFSET in your formulas for them
to work. See my page
Insert a Row using a Macro to maintain formulas
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


"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

INSTERING A ROW
 

Hi Ronald,
See my page
Lastcell, Reset Last Used Cell
http://www.mvps.org/dmcritchie/excel/lastcell.htm
and you will have to change your formulas to use OFFSET
as noted on the page.

Wording -- be careful with the words rows, columns, black
and blank. I can see English is not your native language.
I'm certainly glad I could learn programming languages
without having to learn another spoken language at the
same time.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"RONALD" wrote...
I am trying to find a way to insert a row ...