How to use variable inside Range?

Hello amithreat,

Here is another method. This will select the cells "N10:T10,V10,X10:Z10" on the Active Sheet. The Union method is used to create a range of non contiguous cells. The Resize method allows you to change the number of Rows and Columns for a Range or a single cell.

Sub TestExample()

  Dim R As Long
  Dim Rng As Range
  
    R = 10
      Set Rng = Union(Cells(R, "N").Resize(, 7), Cells(R, "V"), Range("X" & R & ":Z" & R))
      Rng.Select
    
End Sub