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

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

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

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

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

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


Gord Dibben MS Excel MVP

On Sat, 7 Apr 2007 06:46:02 -0700, Texas-Ron
wrote:

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