title: Reference a named Excel variable using VBA
body: <p>Situation: I'm using Excel 10.  I have a named variable that uses a formula to compute it's value.  This is a named variable, not a named range (in the 'Name Manager' the name "MaxDate" refers to "=MAX(Sheet1!B:B)" where column B is a list of dates).  The computed value does not appear in any cells by itself, but rather is used in various formulas within the spreadsheet.</p>
  
  <p>My problem:  How can I reference this named variable in VBA code?  Using range("MaxDate").value does not work.  I know I can simply put the value into a cell and reference the cell, but I'd like to find a way to reference the variable directly.  Any ideas?Thanks.</p>