Hi K. Price,
Even though your question was answered and you thanked
Paul for the answer ...

I have the feeling that you wanted to copy information to that
empty row when you asked for.how to insert a row. In fact
that is more clearly written in your subject. The subject should
only reiterate what is asked for in a question. The question should
be complete without having to look again at the subject.

Take a look at
Insert a Row using a Macro to maintain formulas
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

which may give you some additional material. I don't know how
resize fits into your plan, so you may be looking for a total or
something else.
---
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

"Price" wrote in message om...
gracias Paul!