will insert 4 rows at row 14 if 4 in cell b1

Rows("14:" & 14 + Range("b1") - 1).Insert

--
Don Guillett
SalesAid Software

"SSBG" wrote in message
...
I'm trying to create a spreadsheet where a value in a particular cell will
be
changing. The question i have is, can excel read the data from that cell
and
insert rows after a certain designated row based on that variable value?