Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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, |
#2
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Discussion (Misc queries) | |||
up to 7 functions? | Excel Worksheet Functions | |||
averaging from one selected cell to another | Excel Discussion (Misc queries) | |||
averaging from one selected cell to another | Excel Discussion (Misc queries) | |||
Timestamp cell to left after update | Excel Discussion (Misc queries) |