Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FilterMode does not work? Excel 2003/XML
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 help doesn't work. I got both Excel 2003 and 2007 insta | Excel Discussion (Misc queries) | |||
Array Doesn't work in Excel 2003 | Excel Worksheet Functions | |||
need to work across two sheets in excel 2003 | Excel Worksheet Functions | |||
Keyboard will no work in Excel 2003 | Excel Discussion (Misc queries) | |||
Find does not work in Excel 2003 | Excel Discussion (Misc queries) |