Charlie
The scroll bar scrolls smoothly and rotating the mouse wheel scrolls
smoothly too.

Sandy

"Charlie" wrote in message
...
Not to ask a dumb question, but when you drag the scroll bars does the
sheet
actually scroll or does it just display that useless little yellow
"ToolTip"
that shows the row or column? Then the sheet jumps to that row/column
when
you release the scrollbar? My workbooks go into that state now and then
and
I'm not sure what causes it, but it may be related.

"Sandy" wrote:

That doesn't work either I'm afraid.



"JLGWhiz" wrote in message
...
You have to Activate, then select to get the scroll effect.

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

But if you want to do something to the cell you can use the other
syntax,
like:

Sheets("Current Round").Range("D109") = "My Cell"

It's a design thing.

"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