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