Scroll to selected cell
Sandy,
As long as Current Round is the activesheet:
Application.Goto Sheets("Current Round").Range("D109"), True
HTH,
Bernie
MS Excel MVP
"Sandy" wrote in message
...
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
|