title: Excel VBA scrollscreen automatically
body: <p>Let's say the range <code>(A1:A200)</code> contains a descending order of numbers (from 200 to 1) and I have implemented conditional formatting on the range. </p>
  
  <p>When any cell in A1:A200 matches the source data <code>(Cell B1)</code>, which is continuously updated, it will be highlighted in Yellow in its background. </p>
  
  <p>My question is How can I write a code to scroll the screen to the matched cell(highlighted yellow) and position it in the middle of my screen? </p>
  
  <p>I don't want the <code>".select"</code> function as the matched cell is keep changing and the target cell may not be the active cell. Much appreciate if anyone can offer some help to me. Many thanks!</p>