VBA Syntax - Specifying Range of Rows to Delete Via Variables

MediocreJoker · Jul 14, 2011

Right now I have this:

Code:

        Sheets(i).Select
        Rows("62:180").Delete Shift:=xlUp

Instead I want to do

Code:

Rows(Var1:Var2).Delete Shift:=xlUp

What is the proper syntax?

JoeMo · Jul 14, 2011

Here's one way - variables are x and y:

Code:

Dim x As Long, y As Long
x = 5
y = 10
Range(Cells(x, 1), Cells(y, 1)).EntireRow.Delete shift:=xlUp

wigi · Jul 14, 2011

Or the same but without complicating when it is not needed:

Code:

    x = 5
    y = 10
    Rows(x & ":" & y).Delete

Wigi