View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob
 
Posts: n/a
Default Can't unhide rows

I hide and unhide rows all the time and don't have a problem, but this time
I do with one worksheet in my workbook.

I have tried selecting a cell, or many cells in the area hidden, using the
Go To command in the Edit toolbar, and then using the Unhide feature under
Format on the toolbar without success.

I've checked that the sheet code has the EnableSelection set to
xlNoRestrictons.

I've clicked the last visable cell and dragged the mouse down whilst holding
the left mouse button down and then selecting Unhide (which is my normal
method).

I can hide more rows and then unhide them again, but from row 949 onwards
they will not unhide

Sheet is not locked! All the columns are visable.

AAAaaaarrrrggggg!!!! Any suggestions anyone?

Rob