title: VBA for Excel: How to easily reference to index of the active cell
body: <p>I'm looking for a way to reference to the row and column indices of the currently active cell. I tried something like</p>
  
  <pre><code>Cells(ActiveCell.RowIndex, 5).Value = "something"
  </code></pre>
  
  <p>But that gave me run time error 438.</p>