for/next Correct Syntax for Ranges with variables

**beat** · 08-19-2013, 10:04 AM

Basically what is wrong with this

For i = 11 To 21

If i Mod 2 = 0 Then Range("A" & i & ":" & "DB" & i) = Range("A" & i-1 & ":" & "DB" & i-1)

    
    Next i
End Sub

Thanks

**Solus Rankin** · 08-19-2013, 10:07 AM

You can concatenate the colon and the second range in one string. Like

 Range("A" & i & ":DB" & i)

e/ Also I'm assuming you want to take the values of those ranges so it would be:

Range("A" & i & ":DB" & i).Value =

**AB33** · 08-19-2013, 10:46 AM

Sub test()
For i = 11 To 21

     If i Mod 2 = 0 Then Range("A" & i) = Range("A" & i).Offset(-1).Resize(, 106)

Next i
End Sub

**shg** · 08-19-2013, 11:14 AM

Or ...

    For i = 10 To 20 Step 2
        With Rows(i).Range("A1:DB1")
            .Value = .Offset(-1).Value
        End With
    Next i

Re: for/next Correct Syntax for Ranges with variables