When I follow those steps it keeps giving me errors after the with me part.
(.UsedRange
..Rows.Hidden = False)

That is the exact part it is having issue with.
Any ideas again thanks for your help