Scroll to active cell.

[omairhe]

Hello,

I want to scroll row to the bottom of the screen where the active cell resides.

ActiveWindow.ScrollRow = Selection.Row

This line will scroll to the active cell but will bring it to the top of the screen, whereas I want it to be at the bottom of the screen.

Will appreciate.

 

[Fluff]

As that one line of code, on it's own, is totally meaningless, I've no idea.

 

[omairhe]

Another option

   Dim Cl As Range
   Set Cl = ActiveCell
   Application.Goto ActiveCell.EntireRow
   Cl.Select

I'll stick to this one now that I tried. simple solution that works.
Thanks again..

 

[Fluff]

Glad to help & thanks for the feedback.