Determinar Range no VBA

Question

Como faço para escrever no vba o seguinte range abaixo, com variável?

Range [Cells(i, 2), Cells(i, 3), Cells(i, 4), Cells(i, 5), Cells(i, 6), Cells(i, 7), Cells(i, 8), Cells(i, 9), Cells(i, 10), Cells(i, 11), Cells(i, 13), Cells(i, 14), Cells(i, 15), Cells(i, 16), Cells(i, 17), Cells(i, 18), Cells(i, 26), Cells(i, 27)].Select

se puder corrigir agradeço

Answer 1

Range("B1:K1,M1:R1,Z1:AA1").Select

---

Anderson Diniz

Answer 2

Sub Macro2()


Dim i As Long

i = 1

    Range("B" & i & ":K" & i & ",M" & i & ":R" & i & ",Z" & i & ":AA" & i).Select
    
End Sub

---

Anderson Diniz