title: excel 2010 edit multiple hyperlinks VBA, macro
body: <p>...a simple question (for some :)</p>
  
  <p>the goal is to change a part of hyperlinks in a range of cells</p>
  
  <ul>
  <li>sheet 'Progress'</li>
  <li>range 'd9:d38'</li>
  </ul>
  
  <p>hyperlinks now (rc001 is in D9; rc002 in D10 and so on)</p>
  
  <p><code>..\..\..\..\..\..\..\AppData\Roaming\Microsoft\Excel\VNHS2_Reconciliation_report_RC001.xlsx</code></p>
  
  <p>hyperlinks to be</p>
  
  <pre><code>VNHS2_Reconciliation_report_RC001.xlsx (rc001 increasing by 1 up to 030)
  </code></pre>
  
  <p>anyone? pretty please :)</p>