Unhide rows 1 - 9

[W Wolfe]

I have hidden rows 1 - 9 and cannot find how to unhide these rows. Help.

W. Wolfe

 

[W Wolfe]

PS I am using Excel 2007.

 

[Rick Rothstein \(MVP - VB\)]

If those are the only rows that are hidden, just select the entire worksheet
(click the blank box where the row and column header meet), right-click the
selection and click on Unhide. If there are other hidden rows that you want
to keep hidden, click on the 10 in Row 10's header and drag up to the blank
box where the row and column headers meet, then release the mouse button.
Next, right-click the selection and click on Unhide.

Rick

 

[JMay]

Sub Unhideonetonine()
ActiveSheet.Rows("1:9").Hidden = False
End Sub