title: Is there a way to find range of a pivot table
body: <p>Excel 2013. I have pivot table, which grows and shrinks according to the data rows.  For example, 
  1. For the Row label, I have list of all products
  2. For the Column label, I have list of manufacturers
  3. For the Values, I have a count of 1 for the manufacturer.  This would tell me how many manufacturers produces the same product.</p>
  
  <p>Therefore the product list (row) grows and so does the Manufacturer list (columns) expands.</p>
  
  <p>My question: Is there a way to get the range of the pivot, for example if the pivot tables starts at A1 and there are 10 products and 10 manufacturers, then the range of the pivot table would be $A$1:$K$12 (without Total for row or Total for column).</p>
  
  <p>Is there a quick way to extract the range $A$1:$K$12?  </p>
  
  <p>Thank you in advance,</p>
  
  <p>G.</p>