title: Excel VBA - Cell(#,#) with variables
body: <p>Im wondering if its possible to enter a variable that refers to a range into a Cell objects parameters. ie:</p>
  
  <pre><code>Dim visibleRows As Range
  Dim visibleColumns As Range
  
  Set visibleColumns = (G:P)
  Set visibleRows = (10:20)
  
  Cells(visibleRows, visibleColumns).Formula = "enter formula here"
  </code></pre>
  
  <p>I want to do this because the ranges within each of those variables will change based on parameters in the spreadsheet. Thanks in Advance.</p>