Okay :

On Error Resume Next
Columns("A").SpecialCells(xlBlanks).Offset(-1).Select
On Error GoTo 0

This works up to here.....this is what I'm trying to accomplish after I have
that selected.....

If the value of the cell is equal to 16 then insert 14 rows, if the value is
15 then insert 15 rows, if the value 14 then insert 16 rows, if the value is
13 then insert 17 rows...etc etc on down the list. It's a pretty nasty
sounding IF statement, how do I get something like that to work and what
would the code look like??? THANKS!!!

THANKS!!!!!