selected cell - top left
 

Hello,

I have frozen panes in my excel screen with command buttons - when I click a
button I want a certain cell to be in the top left corner of the worksheet
(under the frozen pane)

any ideas on code for this?

thanks,

You could try something like

With ActiveWindow
If Panes.Count 1 Then
.Panes(4).VisibleRange.Cells(1, 1).Select
End If
End With


--
HTH

Bob Phillips

"Ciara" wrote in message
...
Hello,

I have frozen panes in my excel screen with command buttons - when I click
a
button I want a certain cell to be in the top left corner of the worksheet
(under the frozen pane)

any ideas on code for this?

thanks,