View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Yazeed Yazeed is offline
external usenet poster
 
Posts: 6
Default Is there a way to get the range from a frozen panes using C#?

Hi all,

I was wondering if there is a way to get the range from the frozen panes in
excel using interop v.12??

Or is there a property associated with the range indicating its frozen or
not??

the only thing i could accomplish is to select a range then check
ActiveWindow.FreezePanes, but this will return true if you have any range
frozen other than the selected one, so i want to get the range from the
current Frozen panes.

Thanks in advance.