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