H Cstolworthy and welcome to the forum.

Excel is great for exposing what it does and the vocabulary needed to do things. You need to "Record a Macro" doing the steps you describe above. Then look at what Excel recorded in the Macro Recorder. This will give you great insite to the VBA vocabulary and how it does stuff.

After seeing the vocabulary for inserting a row you are ready to build a loop to run down the rows looking for your constants. Put an IF .. Then statement in the loop and only insert a row if a constant is found.

To loop down rows use "Cells(RowCtr,ColCtr)" where RowCtr and ColCtr are numbers (longs).

Do a little debugging using Break Points in the VBA IDE (Visual Basic for Applications, Integrated Development Environment) and stepping through your code and you'll be a VBA expert in no time.

I hope this is a lot more helpful than just giving you THE answer. (Give a fish vs Teach to fish)