Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Is RowHeight=0 the same as Hidden
I'm manipulating rows, and I want to know if I can distinguish between rows
that have been hidden, and rows that have been set to RowHeight = 0. Thanks M |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is RowHeight=0 the same as Hidden
No. The hidden property indicates if the cell is visible. YO ucan have a visible row that has a height of zero. when yo utake a hiddne row and display it it returns to the same height as before you hide the row. Some people rather than hide a row will make the row height 0 but that is not the saqme thing as hidding the row. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=181399 Microsoft Office Help |
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Is RowHeight=0 the same as Hidden
If you hide a row its height becomes 0
If you set a row's height to 0 it becomes hidden AFAIK there is no way to distinguish which method was used to hide and make the height 0. Regards, Peter T "Michelle" wrote in message ... I'm manipulating rows, and I want to know if I can distinguish between rows that have been hidden, and rows that have been set to RowHeight = 0. Thanks M |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Is RowHeight=0 the same as Hidden
If you set the row height to zero, the Hidden property of that row will
become True. It is usually better to Hide the row because it is then not necessary to "remember" what the height used to be before you hid it. -- Gary''s Student - gsnu201001 "Michelle" wrote: I'm manipulating rows, and I want to know if I can distinguish between rows that have been hidden, and rows that have been set to RowHeight = 0. Thanks M |
#5
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Is RowHeight=0 the same as Hidden
On 2/22/2010 7:55 AM, Michelle wrote:
I'm manipulating rows, and I want to know if I can distinguish between rows that have been hidden, and rows that have been set to RowHeight = 0. Thanks M Just note that in Excel 2007, the row is "Hidden" even with a value of 0.5. Don't quote me on this, but I believe in versions around Excel 97, a Row height of 1 or 2 also returned true. Sub Demo() Rows(1).RowHeight = 0.5 Debug.Print Rows(1).Hidden ' <- True End Sub = = = = = = = HTH :) Dana DeLouis |
#6
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Is RowHeight=0 the same as Hidden
That is a great answer - thanks
M "Dana DeLouis" wrote in message ... On 2/22/2010 7:55 AM, Michelle wrote: I'm manipulating rows, and I want to know if I can distinguish between rows that have been hidden, and rows that have been set to RowHeight = 0. Thanks M Just note that in Excel 2007, the row is "Hidden" even with a value of 0.5. Don't quote me on this, but I believe in versions around Excel 97, a Row height of 1 or 2 also returned true. Sub Demo() Rows(1).RowHeight = 0.5 Debug.Print Rows(1).Hidden ' <- True End Sub = = = = = = = HTH :) Dana DeLouis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is RowHeight=0 the same as Hidden | Excel Discussion (Misc queries) | |||
set rowheight property | Excel Programming | |||
Format RowHeight question | Excel Programming | |||
How to break the rowheight limit | Excel Programming | |||
Slow RowHeight behavior | Excel Programming |