Any way to use toolbar button to delete cells and move cells "up"?

[Texas-Ron]

Excel-XP / Excel 2002...
- The toolbar button DELETE CELLS is programmed to (Delete + shift cells
LEFT).
- I am looking for a way to select a varying range of cells...(use a toolbar
button to delete those cells...then shift cells UP).
- I tried with a macro...but macro will only delete the specific range of
cells in the macro formula.
Any suggestion appreciated.
Hopeful Regards - Texas-Ron

 

[Don Guillett]

Test first

Sub shiftup()
Selection.Delete Shift:=xlUp
End Sub

 

[Gord Dibben]

Sub Delete_Shift()
Selection.Delete Shift:=xlUp
End Sub


Gord Dibben MS Excel MVP