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

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.
 
Y

Yazeed

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;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top