Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Frozen Panes? | Excel Discussion (Misc queries) | |||
PIA and Frozen Panes | Excel Programming | |||
How to select Visible Cells range minus 2 rows (frozen panes) | Excel Programming | |||
frozen panes | Excel Discussion (Misc queries) | |||
frozen panes question | Excel Programming |