View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 363
Default Move/Scroll Specific Cell(Row) into the centre of the Screen ?

I am having Application.ScreenUpdating=TRUE used so i can SEE the DATA
behind a Userform.
But i am currently Selecting a specific Cell in Column A and Offseting it to
Offset(25,0) to try to get it to Be in the Center of the Screen.

But it does not seen to work real well according to where the rows were LAST
positioned.
Is there a code to Position a Row/Cell in the Centre of the Screen.
I need the user to be able to SEE the values in Column C in relation to the
Value in Column A used as the Offset Cell.

Corey....