Addins: Excel macros can be saved as
addins (*.xla) so that they load up automatically.
After the file is saved as an *.xla it will needed to
be loaded: Tools/Addin, then select the designated
macro.
The following macro creates double spaces between
select rows.
Sub
rowDouble()
'
Double Macro
' Macro
recorded 10/10/2002 by mchirico
'
mcount =
Range(ActiveWindow.RangeSelection.Address).Count
mrow =
Range(ActiveWindow.RangeSelection.Address).Row
mcol =
Range(ActiveWindow.RangeSelection.Address).Column
k =
0
For n = 1 To mcount
ActiveSheet.Cells(mrow + n + k,
mcol).Select()
ActiveSheet.Cells(mrow
+ n + k, mcol).Activate()
Selection.EntireRow.Insert()
k =
n
Next n
End
Sub