title: How to refer a cell of another sheet mentioned in a cell through VBA
body: <p>I am having a excel file named "Book1" with "Sheet1" and "Sheet2". In Sheet1, Cell Value of A1 is "'[Book1.xlsb]Sheet2'!$A$14", which is derived as some formula result. I want cell reference mentioned in cell A1 to be selected through VBA.</p>
  
  <p>I have put VB Code as</p>
  
  <pre><code>Range(Range("A1")).Select or Range([Indirect("A1")]).Select
  </code></pre>
  
  <p>This code works only when cell referred in A1 is in same sheet, but it doesn't work if cell referred is in different sheet</p>
  
  <p>Can someone help to solve this please</p>