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,
|