hidden/0 height rows
Try this:
<Data <Filter
And *UNCHECK*
"AutoFilter".
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
<Scott Brooks wrote in message
...
Hello all,
I have a 7000+ row worksheet; rows 2-1180 and 1185-7028 are
hidden/have a 0 height. I learned from a previous post that I can
manually "drag" each row and change its height back to 14.25. Since
this is not my worksheet (a colleague asked me to "fix" it) I am loath
to manually drag 7000+ rows to the correct height. I have highlighted
the workbook, right clicked; change height to 14.25 and this only
changes the height of "visible" rows. Row 1 is frozen (with titles).
The numbers for rows 1181 to 1184 are blue.
This was created with MS Excel 2003 and I am using MS Excel 2007.
Thanks for any ideas and advice.
|