Hello Everyone,

I have a macro that I want to run when it is activated but cannot get it to work the way I want it to!
On my sheet different rows between 11 and 35 are hidden. Some of the hidden rows contain data
that I want to reveal when the "PaperWork" Macro is run. The problem is that the macro only sorts
the unhidden cells leaving the hidden cells unsorted! I do not know why but any help is appreciated.
The macro is very basic and below:

Sub PaperWork()
Range("B11:Y35").Select
Selection.Sort Key1:=Range("B11"), Order1:=xlAscending, Header:=xlGuess _
, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End Sub

I have been trying to get this work for about 3 hours now!!!
Thank you very much for any help.