I should also mention that Column 11 is a formula that
calculates a number

-----Original Message-----
Assume the cell with xyz is selected

x = 3
ActiveCell.offset(1,0).Resize(x,1).EntireRow.Inse rt

--
Regards,
Tom Ogilvy

Christel wrote in
message
...
I have a spreadsheet where I need to insert x number of
rows below the row where the column = "x" For ex.

A B C D
abc 123 xyz 3 I need excel to insert 3 rows
beneath
this row.

Any help is appreciated, because I'm not having much
luck!

Thanks!


.