title: Get Cell / Range Reference For Named Range
body: <p>I have multiple named ranges Say (Report1.. Report2...); each of them contains multiple rows and columns (for instance AI349:AZ368  ... etc) i would like to figure out the actual cell references for the named ranges.</p>
  
  <p>In theory i will be given a list of named ranges and i have to export the actual cell reference for those named ranges.</p>
  
  <p>any help? all i can seem to do is just figure out the cell reference for the first row/column rather than the whole range.</p>
  
  <p>kind regards</p>