Delete cells - auto move
You know when you Delete cells in Excel, it asks you if you want to move the cells up or left to fill in the gap. What is the code to Delete a Range (A4:B6) and then automatically have the cells move up to fill the gap? Thx, Al |
Delete cells - auto move
Al,
You could just turn on the recorder to discover the code. You would find something like..... Sub Macro1() ' ' Macro1 Macro ' Macro recorded 03.11.2003 by Kevin Stecyk ' ' Range("A4:B6").Select Selection.Delete Shift:=xlUp End Sub I think you could simplify the code slightly as follows: Sub Macro1() Range("A4:B6").Delete Shift:=xlUp End Sub Hope that helps. Regards, Kevin "Al" wrote in message ... You know when you Delete cells in Excel, it asks you if you want to move the cells up or left to fill in the gap. What is the code to Delete a Range (A4:B6) and then automatically have the cells move up to fill the gap? Thx, Al |
Delete cells - auto move
Al
Sub Delete_Shift_Up() Range("A4:B6").Delete Shift:=xlUp End Sub More generic....Selection.Delete Shift:=xlUp......you pre-select the range Gord Dibben XL2002 On Mon, 3 Nov 2003 21:03:58 -0800, "Al" wrote: You know when you Delete cells in Excel, it asks you if you want to move the cells up or left to fill in the gap. What is the code to Delete a Range (A4:B6) and then automatically have the cells move up to fill the gap? Thx, Al |
Delete cells - auto move
Forgot about the recorder .. thx for the tip. And that is just what I was looking for. Thx again Kev, Al -----Original Message----- Al, You could just turn on the recorder to discover the code. You would find something like..... Sub Macro1() ' ' Macro1 Macro ' Macro recorded 03.11.2003 by Kevin Stecyk ' ' Range("A4:B6").Select Selection.Delete Shift:=xlUp End Sub I think you could simplify the code slightly as follows: Sub Macro1() Range("A4:B6").Delete Shift:=xlUp End Sub Hope that helps. Regards, Kevin "Al" wrote in message ... You know when you Delete cells in Excel, it asks you if you want to move the cells up or left to fill in the gap. What is the code to Delete a Range (A4:B6) and then automatically have the cells move up to fill the gap? Thx, Al . |
All times are GMT +1. The time now is 03:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com