Unfilter all rows

[HWL]

This code doesn't work properly. It selected everything but doesn't seem to unfilter. What am I missing?

Sub test()
Sheets(1).Cells.Select
Selection.EntireRow.Hidden = False
End Sub

 

[hiker95]

HWL,


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Sub test()
Sheets(1).AutoFilterMode = False
End Sub

 

[HWL]

Thanks I tried
Sheets(1).ShowAllData

Works perfect, unfilters hidden rows and columns