Test first

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

--
Don Guillett
SalesAid Software

"Texas-Ron" wrote in message
...
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