title: Get cell value using named range in Excel VBA
body: <p>I'm doing my first Excel VBA project and am having some trouble.
  I'd like to get the value in a cell in the CurrentBalance column.  I'll be using ActiveCell.Row to get the row number.  And I'd like to use a named range for the column in case I need to insert additional columns later.</p>
  
  <p>So what I'd like to have is:
  BalanceVariable = "CurrentBalance"$ActiveCell.Row</p>
  
  <p>I've been trying things for an hour and can't get it to work.  I've tried Range and Cell and othe things.  Suggestions?</p>