View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default Scroll selection into view

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

--
Don Guillett
SalesAid Software

"raj" wrote in message
...
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.