The suggestion to go to the group of cells did not work as originally
suggested. It gave me an idea. I went to row 200 column A and then
changed the row height. Turns out that all of the hidden rows were set
to a height of zero. I found that I had to change the height of the
first and last row to some real height say 16. Then I could go back to
select the entire range and change the whole group of hidden (zero
height rows) to a height of 16 and get them to be visible. Thanks for
the idea/suggestion


--
rdrunner
------------------------------------------------------------------------
rdrunner's Profile: http://www.excelforum.com/member.php...o&userid=28313
View this thread: http://www.excelforum.com/showthread...hreadid=478989