View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Conan Kelly Conan Kelly is offline
external usenet poster
 
Posts: 98
Default 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