I want to add spaces say every 10 rows for about 15,000 rows. I'm guessing you can create some type of macro to do that but I'm not sure how I would go about doing that.. I recorded a little test macro that looks like this... Sub Space() ' ' Space Macro ' Macro recorded 12/19/2005 by A ' ' Keyboard Shortcut: Ctrl+Shift+S ' Range("A10,A20,A30,A40,A50").Select Range("A50").Activate Selection.EntireRow.Insert End Sub Is there some type of formula I can use in that first "Range" line instead of A10,A20,A30, etc...for ex. (A10+10*15000) or something to that effect. (that doesnt work btw) Or is there a better way to insert 1500 rows ever 10th row