title: How to change cell value with data in visible area of Excel sheet?
body: <p>I hope to explain as best I can.</p>
  
  <p>For example, I have a scrollable horizontal daily calendar, in an Excel sheet. In that, I have a left column with some items, and the sheet is "frozen" so that this column is always visible with any horizontal calendar scroll.</p>
  
  <p>So imagine that I scrolled the calendar, and a different year is in the visible scrolled area. On that (always visible) left column, I want a cell to change the value to the current visible year.</p>
  
  <p>I have searched over forums, but no luck or even a first idea to start with.</p>
  
  <p>Thanks.</p>