View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 168
Default macro to unhide row

If you want an hidden/unhidden macro, this will work.

Sub HideUnhideRow()
If Range("A1").EntireRow.Hidden = True Then Range("A1").EntireRow.Hidden =
False Else: Range("A1").EntireRow.Hidden = True
End Sub

May not be the best way, but gets the job done.
HTH,
Paul

"Benjamin" wrote in message
...
Could someone help me with some code to unhide the first row of a
worksheet?
Ideally I would like to attach to a button.

Thank You.