Thread: Is RowHeight=0 the same as Hidden
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Michelle Michelle is offline
external usenet poster
  
Posts: 204
Default 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 With QuoteReply With Quote