Is there a way to get the range from excel frozen panes?

[ronnysaid]

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.Fr eezePanes, 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.

[ronnysaid]

Solution found

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

Application.Act iveWindow.Visib leRange[1,Type.Missing] as Range --> this will return the cell where the froze began, if you want the whole range then use:

Application.Act iveWindow.Visib leRange as Range;