Is there a way to get the range from a frozen panes using C#?

  • Thread starter Thread starter Yazeed
  • Start date Start date
Y

Yazeed

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.
 
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;
 
Back
Top