Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cursor to upper left of frozen cells (in macro)
I have crudely written a macro that takes the cursor to A1 on all worksheets
in a workbook. I'm hoping to add a command that will send the curso to the upper left of any frozen cells first, then go to A1 (basically I want it to perform Ctrl-Home first). Does anyone have any advice on this? Below is the code I am currently using. Dim wk As Worksheet For Each wk In ActiveWorkbook.Worksheets wk.Activate Range("A1").Select Next wk Sheets(1).Activate Thanks for the help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cursor movement frozen | Excel Discussion (Misc queries) | |||
Third left part of the screen is frozen | Excel Discussion (Misc queries) | |||
I have arrowheads in upper left of some cells. How can I remove? | Excel Discussion (Misc queries) | |||
Remove green mark upper left several cells Excel? | Excel Worksheet Functions | |||
How to change location A1 cell from upper right to upper left? | Excel Discussion (Misc queries) |