View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Marsh[_2_] Tim Marsh[_2_] is offline
external usenet poster
 
Posts: 14
Default scrolling to a specific cell

sorry - having a bit of a mind-block. I have a worksheet with a column of
dates and would like to auto-scroll to the current date (if available) in
column B, every time the sheet is activated (so that the row is visible for
entering fresh data)... i know i should be able to do this, but just can't
think how... its been a long day! Can anyone give me the answer?

tia,

tim