INSTERING A ROW

R

RONALD

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
 
N

Nigel

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 said:
I am trying to find a way to insert a row between a column with formulas
Click to expand...
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
 
D

David McRitchie

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.
 
Top