selected cell - top left

[Guest]

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,

 

[Bob Phillips]

You could try something like

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