Answers for "vba delete rows in a for each loop"

VBA

0

vba excel delete every other row

Sub Delete_Even()
 
 Application.ScreenUpdating = False
lr = Cells(ActiveSheet.Rows.Count, 1).End(xlUp).Row
 
If lr Mod 2 = 0 Then
Else
lr = lr - 1
End If
 
For i = lr To 1 Step -2
    Rows(i & ":" & i).Delete Shift:=xlUp    
Next i
 
  Application.ScreenUpdating = True
 
End Sub

Posted by: Guest on February-02-2021

Source

Code answers related to "vba delete rows in a for each loop"

Code answers related to "VBA"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#