View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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,