How can i add a button to the bottom of a spreadsheet which will
automatically delete/add blank lines when activated. Therefore you can click
it whenever you need to use this in a spreadsheet template?

I believe you would need two buttons.

One for deleting blank rows and one for inserting blank rows.

There is a built-in button for inserting rows.

ToolsCustomizeCommandsInsert.

Drag the Insert Rows button to your Toolbar.

For a delete blank lines macro, record yourself selecting a column and
F5SpecialBlanksOKEditDeleteEntire Row.

You'll get this code which you assign to a button.

Sub Macro1()
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.EntireRow.Delete
End Sub


Gord Dibben MS Excel MVP


On Tue, 7 Aug 2007 09:26:04 -0700, GD wrote:

How can i add a button to the bottom of a spreadsheet which will
automatically delete/add blank lines when activated. Therefore you can click
it whenever you need to use this in a spreadsheet template?