Scroll selection into view

[raj]

Hello, I hope someone will be able to help me, please.

In Excel XP, I have a program that when the user double
clicks a value in a "SUMMARY" sheet, the program takes the
user to the details in a "DETAIL" sheet.

The program uses "Find" to locate the appropriate data.
The "DETAIL" sheet is activated and it all works great,
except one thing.

The selection (always an entire row) is not visible (off
screen). I need a way to scroll the currently selected row
into view (preferably toward the center of the screen)
without losing my selection.

Your example code would be most appreciated. Thank you
very much in advance for your assistance on this.

 

[Amit Shanker]

ActiveWindow.ScrollRow = 1 'Or your required row number here

Amit

 

[Don Guillett]

try
Sub gothere()
Application.Goto Range("a21"), Scroll = True
End Sub

 

[arno]

Hi,

I need a way to scroll the currently selected row
into view (preferably toward the center of the screen)
without losing my selection.

if you want to see cell(x, y):

ActiveWindow.ScrollColumn = y
ActiveWindow.ScrollRow = x

regards

arno