Can't Unhide Hidden Rows

[SpikeGiles]

I have a value in a hidden row that I now want to edit. I protected the workbook structure and the worksheet. No I find that even if I unprotect the workbook and the worksheet, I can't unhide the row! Can anyone tell me what is going on here?

 

[VoG]

Have you tried selecting from the row above to the row below then unhiding?

 

[SpikeGiles]

Indeed yes. I also selected rows above and below and made the row height 15 to assure the hidden row did not just have 0 height.

 

[VoG]

Try running this

Sub UnhideRows()
Dim LR As Long
LR = Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row
Rows("1:" & LR).Hidden = False
End Sub

 

[SpikeGiles]

Well, my associate in the office came in and double clicked on the row bar at the hidden row site and the rows appeared. Just for grins I hid the row again and tried to unhide with the unhide command; no luck. Double clicking worked again. Can't figure out what the deal is, but at least now I know another way. Thanks.