View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default Scroll to selected cell

i ran a test macro on a sheet & "select" did move the screen to the
selected cell. perhaps you have application.screenupdating set to
false?
hth
susan



On Jul 24, 8:51*am, "Sandy" wrote:
I have a piece of code on a button on Sheets("Current Round"). The button is
at the top of the sheet.

* * If *******Code******* Then
* * * * MsgBox "There are incomplete entries etc"

* * * * Sheets("Current Round").Range("D109").Select

* * * * Exit Sub
* * End If

How can I force Cell "D109" not only to be selected but also visible in the
window.

Thanks
Sandy