Can't unhide first row

[odonovanc]

I have inherited a spreadsheet and the first 4 rows are hidden. No matter what I do, I cannot figure out how to unhide them. I've done the f5 and type in the rows and then went to cells format and unhide rows but they do not show up.

Help???

 

[Joe4]

One way is to run this one line macro:

Sub Unhide_Rows()
    Rows("1:4").RowHeight = 14.4
End Sub

 

[odonovanc]

One way is to run this one line macro:

Sub Unhide_Rows()
    Rows("1:4").RowHeight = 14.4
End Sub

This does not seem to be working. I am not super strong with macros but I found a tutorial online and this is not unhiding these rows

 

[Joe4]

Perhaps you have frozen panes as well.

Try this variation:

Sub Unhide_Rows()
    Rows("1:4").RowHeight = 14.4
    ActiveWindow.FreezePanes = False
    Range("A1").Select
    MsgBox "Macro complete!"
End Sub

Where did you place the VBA code?
Make sure you are in the correct sheet when you run it.
If you run it correctly, you will get a message box at the end.

 

[Fluff]

Try

Sub Unhide_Rows()
    ActiveSheet.ShowAllData
End Sub

 

[odonovanc]

This one worked. Thank you very much.

 

[Joe4]

This one worked. Thank you very much.

Which one?
My code or Fluff's?
I am just curious in case this comes up again, I will know which one to recommend.