title: Referencing Cells within Named Range in VBA
body: <p>I'd like to know if its possible to use Cells(r, c) within a named range in VBA.
  Ex.: I have named range "Test" to be A1:B5  and I am working on a Macro that loops through this range, however I'd like to avoid explicit declarations of ranges as much as possible, so sheet manipulation can be as easier as possible.</p>
  
  <p>In case what I said wasnt possible, I basically need to be able to loop/write through cells in the named ranges, if there is another approach for this I'd be more than glad to get a suggestion.</p>
  
  <p>Thanks!</p>