can excel insert rown based on variable data in a cell?

S

SSBG

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?
 
D

Don Guillett

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

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