Have a look at RESIZE in vba help

--
Don Guillett
SalesAid Software

"Pat" wrote in message
...
It it possible to insert a specified number of rows into a
Worksheet such that the number of rows inserted is equal
the number specified in a cell at the bottom of that same
spreadsheet? Eg. if Cell A72 = 218 then a macro can be
programmed to insert 218 rows from A2 downward.

Pat