Need macro to delete rows in a specific range

[lostinVBA1]

Hi
I need a Macro to delete rows which have 0 as value in col R between row 4 and 34 only rest of them should stay .Thank you!

 

[Joe4]

Welcome to the Board!

There are various different ways. Here is one:

Sub MyDeleteRows()

    Dim rw As Long
    
    Application.ScreenUpdating = False
    
    For rw = 34 To 4 Step -1
        If Cells(rw, "R") = 0 Then Rows(rw).Delete
    Next rw
    
    Application.ScreenUpdating = True
    
End Sub

 

[lostinVBA1]

Hi
I need a Macro to delete rows which have 0 as value in col R between row 4 and 34 only rest of them should stay .Thank you!

Thank you very much! works perfect

I am new to macros .. what does " Dim rw As Long " mean?
I as looking to look add a range in column

 

[Joe4]

See here: https://docs.microsoft.com/en-us/office/vba/language/concepts/getting-started/declaring-variables

You should always declare your variables. If you do that, along with using "Option Explicit", it will help prevent typos and other errors.
See: https://www.excel-easy.com/vba/examples/option-explicit.html