F
Fod
Hi,
I've imported an XML file into Excel. A list is generated on one of the sheets
with auto-filter (which seems to work - both directly and from a VB macro
lists has an auto-filter, based on the column headers.
I'm trying to write code that will reset the auto filter, so it will display
all records, without success.
However, the filtermode property for the worksheet returns false; even the
following code taken from this list does not seem to reset that autofilter.
On Error Resume Next
For Each wb In Application.Workbooks
For Each sh In wb.Worksheets
sh.ShowAllData
Next
Next
On Error GoTo 0
I've imported an XML file into Excel. A list is generated on one of the sheets
with auto-filter (which seems to work - both directly and from a VB macro
lists has an auto-filter, based on the column headers.
I'm trying to write code that will reset the auto filter, so it will display
all records, without success.
However, the filtermode property for the worksheet returns false; even the
following code taken from this list does not seem to reset that autofilter.
On Error Resume Next
For Each wb In Application.Workbooks
For Each sh In wb.Worksheets
sh.ShowAllData
Next
Next
On Error GoTo 0