View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default How do you unhide the first three rows of a worksheet?

Excel versions behave differently when it comes to this, which one are you
using ? Anyway, here's a pretty universal macro solution:

Sub Unhidem()
Dim R As Long
For R = 1 To 100
If Rows(R).Hidden = True Then
If MsgBox("Wanna see " & R & " ?", _
vbYesNo + vbQuestion) = vbYes Then
Rows(R).Hidden = False
End If
End If
Next
End Sub

HTH. Best wishes Harald

"jwwj232" skrev i melding
...
I tried the steps illustrated in the help file but I am still unable to
unhide the first three rows of a worksheet.