title: How to use indirect reference to select a single cell or range in vba
body: <p>I need simply a code for selecting a cell, however that cell to select changes. I have a cell in the workbook that will identify what cell it should be. Cell A1 contains the cell # that should be selected. </p>
  
  <p>In this example cell A1 contains the word "P25", so I want the below code to reference A1 for the indirect cell ref to P25, thus select cell P25. </p>
  
  <p>I tried both of these lines separately:</p>
  
  <pre><code>Sub IndirectCellSelect()
  
       Sheet.Range(INDIRECT(A1)).Select
       Range(INDIRECT(A1)).Select
  
  End Sub
  </code></pre>
  
  <p>I get the error Sub or Function is not defined, when it gets to the word INDIRECT </p>