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
|