title: In Excel, can I use a hyperlink to run vba macro?
body: <p>I have a spreadsheet that has many rows of data. I would like to be able to click on a cell that will run a macro using the data from that row. Since the number of rows will always be changing, I though a hyperlink for each row might be the best way.</p>
  
  <pre><code>   ROW MeterID   Lat    Long   ReadX  ReadY  ReadZ   CoeffA  CoeffB  CoeffC
     2   10f62gs   34.1   33.3   102.2  231.3  382.2   4.34    22.1    0.002
     3   83gs72g   34.4   31.4   109.2  213.1  372.1   2.23    12.7    0.023
     4   43gS128   33.3   32.2   118.8  138.7  241.8   1.94    5.08    0.107
  </code></pre>
  
  <p>Is there a way to run a vba macro from clicking on a hyperlink and being able to know the row of the cell that clicked on the hyperlink?</p>