title: Excel 2007 - Named Ranges
body: <p>I have a worksheet where data is updated from an external source.  The page contains data from today going out 20 days.  I have a named range for each column i.e. Today ($D$4:$D$50), Tomorrow ($E$4:$E$50), etc, etc.  My issue is that sometime the data from the external source does not contain data so nothing is populated in the columns.  However, when there is data being returned again the name ranges are automatically changing i.e , Today changes to ($F$4:$F$50).  No new columns are being inserted or deleted.</p>
  
  <p>How can I specify / force the name ranges always to stay the same i.e. Today is always column E, I thought that was the point of the $.</p>
  
  <p>Thanks.</p>