Thread
:
Scroll selection into view
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
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.
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]