Unfilter all rows

HWL

Active Member
Joined
Dec 1, 2009
Messages
462
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
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
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).


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

HWL

Active Member
Joined
Dec 1, 2009
Messages
462
Thanks I tried
Sheets(1).ShowAllData

Works perfect, unfilters hidden rows and columns
 

Watch MrExcel Video

Forum statistics

Threads
1,108,806
Messages
5,524,987
Members
409,614
Latest member
wile2u

This Week's Hot Topics

Top