title: Can cell number for vba be given using two variables
body: <pre><code>Dim VAR1, VAR2, VAR3, VAR4, AS variant
  
  VAR1 = Worksheets("Sheet3").Cells(3, "J").Value 
  VAR2 = Worksheets("Sheet3").Cells(3, "K").Value 
  VAR3 = Worksheets("Sheet3").Cells(3, "L").Value 
  VAR4 = Worksheets("Sheet3").Cells(3, "M").Value
  
  =sheet1.range(VAR1,VAR2).COPY
  =Sheet3.range(VAR2,VAR4).Pastespecial
  </code></pre>
  
  <p>for the above i have given cell numbers in Var1 Var2...Var4</p>
  
  <p>Is it possible to define a cell location using two variables,</p>
  
  <pre><code>Var1=B
  Var2=5
  </code></pre>
  
  <p>and somehow combine them to get B5,I want to do this in the macro itself.</p>