How to write vba macro in excel 2013 to delete cells in column
Closed
waisi
TrowaD
- Posts
- 1
- Registration date
- Sunday October 12, 2014
- Status
- Member
- Last seen
- October 12, 2014
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- How to write vba macro in excel 2013 to delete cells in column
- How to write a macro in excel to extract data - Forum - Excel
- Run Macros in Excel: online, shortcuts, VBA - Guide
- Send email with attachment Excel: VBA, macros - Guide
- EXCEL VBA: Application.FileSearch Error in Running Excel 2013 ✓ - Forum - Excel
- Can someone please write me a macro for excel ✓ - Forum - Excel
1 reply
TrowaD
Oct 13, 2014 at 11:53 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Oct 13, 2014 at 11:53 AM
Hi Waisi,
See if the following code yields the desired result:
Best regards,
Trowa
See if the following code yields the desired result:
Sub RunMe() Dim x As Long x = 1 Do Range(Cells(x, "A"), Cells(x + 1, "A")).EntireRow.Delete x = x + 1 Loop Until IsEmpty(Range("A" & x)) End Sub
Best regards,
Trowa