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.

 

[MrKowz]

Welcome to the forums!

Are they hidden with an autofilter? Is the sheet protected?

 

[MajorMajor1]

Welcome to the forums!

Are they hidden with an autofilter? Is the sheet protected?

No to both, but thanks for trying.

 

[MrKowz]

Try this:

1. Press Alt+F11 to open the VBA Editor
2. If the Immediate window isn't open, press CTRL+G to open it
3. Enter the following into the Immediate window:
   

   Cells.EntireRow.Hidden = False

   And press enter.

If that doesn't work, try resetting the height on all of your rows:

1. Follow steps 1 and 2 of the above
2. Enter in the Immediate Window:
   

   Cells.EntireRow.RowHeight = 12.75

 

[MajorMajor1]

Hello -

I tried both suggestions, but I don't know if I'm doing it correctly because I know absolutely nothing about VBA. Is there a final step required to actually run the script?

If not, neither one did anything. On the other hand, the second one definitely didn't do as specified, because my row heights are now set to 12.60.

Thanks for your continuing efforts to help.

 

[klarowe]

Try typing "?Rows(7).Hidden" in the immediate window (alt+F11 to open VBA then ctrl+g to open immediate window) and see what it gives you.

If you did it right it should come back with either "True" for "False" directly below where you typed "?Rows(7).Hidden"

 

[MajorMajor1]

Try typing "?Rows(7).Hidden" in the immediate window (alt+F11 to open VBA then ctrl+g to open immediate window) and see what it gives you.

If you did it right it should come back with either "True" for "False" directly below where you typed "?Rows(7).Hidden"

Thanks for responding. It returned "true".

 

[klarowe]

So then in that same window type "Rows(7).Hidden = False" and see if that fixes it. If it does, then type in the same box: "Range("1:100").Entirerow.hidden = False" and that should unhide all rows 1 through 100 (increase the 100 if there are hidden rows past that)

 

[MajorMajor1]

So then in that same window type "Rows(7).Hidden = False" and see if that fixes it. If it does, then type in the same box: "Range("1:100").Entirerow.hidden = False" and that should unhide all rows 1 through 100 (increase the 100 if there are hidden rows past that)

Okay, that worked! Thanks very much! So now, the question is: why did the unhide rows command not work?

 

[klarowe]

did it work for all the rows, or just that row (7)? And when you originally typed it in, did you put it in that same immediate box or in the larger VBA 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.