Cannot unhide rows

[MajorMajor1]

Excel 2007. Like the subject says. I've tried:

- Selecting all cells and clicking unhide rows
- Selecting all cells and clicking row autoheight (in case I'd inadvertently made the row hjreight 0).

Nada.

I know the rows are missing because the left hand column reads 1 2 3 4 5 8 9 10.

Any help greatly appreciated. I'm going nuts.

 

[MajorMajor1]

did it work for all the rows, or just that row (7)?

Since only rows 6 and 7 were hidden, I did it first literally as you suggested for row 7 only. When I saw that that had worked, I went back and did it for row six, again successfully.

And when you originally typed it in, did you put it in that same immediate box or in the larger VBA box?

The same immediate box.

As far as the highlighting all cells and selecting unhide, did you highlight all the Rows (from the left numbered column) or did you just drag through all the cells? I think you have to highlight all rows (select row 1, press "ctrl+shift+down arrow") and then right click and select unhide rows. I don't think it works by just highlighting the cells.

I first tried selecting rows 5 through 10 by clicking and dragging. When that didn't work, I selected the entire spreadsheet by clicking in the upper left-hand corner, thus selecting everything. Which also didn't work. I tried this many times, so I know I was selecting everything correctly.

 

[klarowe]

I'm not sure then why it didn't work. But I'm also running excel 03 so something may be different with 07

 

[MajorMajor1]

Very curious.

Oh well, at least it's fixed. Thanks very much for your help.