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#?

Ok thanks for all who read the question, i found the answer and here it is
for anyone who is seeking this answer:

Application.ActiveWindow.VisibleRange[1,Type.Missing] as Range -- this will
return the cell where the froze began, if you want the whole range then use:

Application.ActiveWindow.VisibleRange as Range;

"Yazeed" wrote:

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.