Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code equivelent to a key combination?
Hello all,
Does anyone know what the code equivelent to [CTRL] + [Home] is when you have frozen panes in a spreadsheet? I tried recording a macro to find out, but the only thing that it came up with was "Range("Cell Address").Select". Hopefully there is code that will accomplish this because the panes are not frozen in the same place in every file we use. Thanks for any help any one can provide, Conan Kelly |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code equivelent to a key combination?
You select the actual cell
Range("A1").Select -- HTH Bob Phillips "Conan Kelly" <CTBarbarin at msn dot com wrote in message ... Hello all, Does anyone know what the code equivelent to [CTRL] + [Home] is when you have frozen panes in a spreadsheet? I tried recording a macro to find out, but the only thing that it came up with was "Range("Cell Address").Select". Hopefully there is code that will accomplish this because the panes are not frozen in the same place in every file we use. Thanks for any help any one can provide, Conan Kelly |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code equivelent to a key combination?
Please read my post again!
Most of the files I'm using have frozen panes AND they are not frozen in the same place every time. So the cell reference will be different every time. Range("RC").Select will not work for me. If I do a [CTRL] + [Home], it will take me to the cell the panes are frozen on. I want to know how to duplicate that with code. "Bob Phillips" wrote in message ... You select the actual cell Range("A1").Select -- HTH Bob Phillips "Conan Kelly" <CTBarbarin at msn dot com wrote in message ... Hello all, Does anyone know what the code equivelent to [CTRL] + [Home] is when you have frozen panes in a spreadsheet? I tried recording a macro to find out, but the only thing that it came up with was "Range("Cell Address").Select". Hopefully there is code that will accomplish this because the panes are not frozen in the same place in every file we use. Thanks for any help any one can provide, Conan Kelly |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code equivelent to a key combination?
ActiveWindow.ActivePane.VisibleRange.Item(1).Selec t
-- HTH... Jim Thomlinson "Conan Kelly" wrote: Hello all, Does anyone know what the code equivelent to [CTRL] + [Home] is when you have frozen panes in a spreadsheet? I tried recording a macro to find out, but the only thing that it came up with was "Range("Cell Address").Select". Hopefully there is code that will accomplish this because the panes are not frozen in the same place in every file we use. Thanks for any help any one can provide, Conan Kelly |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code equivelent to a key combination?
Thanks Jim, I will try this and see if it works.
Conan "Jim Thomlinson" wrote in message ... ActiveWindow.ActivePane.VisibleRange.Item(1).Selec t -- HTH... Jim Thomlinson "Conan Kelly" wrote: Hello all, Does anyone know what the code equivelent to [CTRL] + [Home] is when you have frozen panes in a spreadsheet? I tried recording a macro to find out, but the only thing that it came up with was "Range("Cell Address").Select". Hopefully there is code that will accomplish this because the panes are not frozen in the same place in every file we use. Thanks for any help any one can provide, Conan Kelly |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code equivelent to a key combination?
While I am sure you did not intend the tone of your post to come across the
way it reads, you should be careful with your reponses. One day in the future you may need Bob's help (he is a genius at VBA) and he may not be inclined to lend a hand. -- HTH... Jim Thomlinson "Conan Kelly" wrote: Please read my post again! Most of the files I'm using have frozen panes AND they are not frozen in the same place every time. So the cell reference will be different every time. Range("RC").Select will not work for me. If I do a [CTRL] + [Home], it will take me to the cell the panes are frozen on. I want to know how to duplicate that with code. "Bob Phillips" wrote in message ... You select the actual cell Range("A1").Select -- HTH Bob Phillips "Conan Kelly" <CTBarbarin at msn dot com wrote in message ... Hello all, Does anyone know what the code equivelent to [CTRL] + [Home] is when you have frozen panes in a spreadsheet? I tried recording a macro to find out, but the only thing that it came up with was "Range("Cell Address").Select". Hopefully there is code that will accomplish this because the panes are not frozen in the same place in every file we use. Thanks for any help any one can provide, Conan Kelly |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code equivelent to a key combination?
Conan, Try
Application.SendKeys("^{HOME}") cheers peterDavey "Conan Kelly" <CTBarbarin at msn dot com wrote in message ... Hello all, Does anyone know what the code equivelent to [CTRL] + [Home] is when you have frozen panes in a spreadsheet? I tried recording a macro to find out, but the only thing that it came up with was "Range("Cell Address").Select". Hopefully there is code that will accomplish this because the panes are not frozen in the same place in every file we use. Thanks for any help any one can provide, Conan Kelly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hour function equivelent help | Excel Worksheet Functions | |||
combination | Excel Discussion (Misc queries) | |||
Combination | Charts and Charting in Excel | |||
Convertig Number to Text - equivelent to single quote | Excel Worksheet Functions | |||
VB combination code | Excel Programming |