| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
In VBA set Slection.AutoFilter show all
How do I set the Selection. AutoFileter Field Criteria to be "All" s there are no filters on that Column. Thanks for your help. Selection.AutoFilter Field:=12, Criteria1:=???? I've tried "All" and (All) but doesn't work. Scot -- Djmas ----------------------------------------------------------------------- Djmask's Profile: http://www.excelforum.com/member.php...fo&userid=2441 View this thread: http://www.excelforum.com/showthread.php?threadid=39659 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
In VBA set Slection.AutoFilter show all
Hi Djmask,
Try: Selection.AutoFilter Field:=12 or ActiveSheet.AutoFilter.Range.AutoFilter field:=12 (with no criteria assignment) --- Regards, Norman "Djmask" wrote in message ... How do I set the Selection. AutoFileter Field Criteria to be "All" so there are no filters on that Column. Thanks for your help. Selection.AutoFilter Field:=12, Criteria1:=???? I've tried "All" and (All) but doesn't work. Scott -- Djmask ------------------------------------------------------------------------ Djmask's Profile: http://www.excelforum.com/member.php...o&userid=24414 View this thread: http://www.excelforum.com/showthread...hreadid=396599 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
In VBA set Slection.AutoFilter show all
Worksheets("Sheet1").ShowAllData I figured it out. Incase anyone else is looking. Amazing what you can find in the manual. -- Djmask ------------------------------------------------------------------------ Djmask's Profile: http://www.excelforum.com/member.php...o&userid=24414 View this thread: http://www.excelforum.com/showthread...hreadid=396599 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
In VBA set Slection.AutoFilter show all
Hi Djmask,
Worksheets("Sheet1").ShowAllData I figured it out. Incase anyone else is looking. Amazing what you can find in the manual. This wiil remove all filters, not the single field filter which appeared to be your object from the originally posed question: How do I set the Selection. AutoFileter Field Criteria to be "All" so there are no filters on that Column. Thanks for your help --- Regards, Norman "Djmask" wrote in message ... Worksheets("Sheet1").ShowAllData I figured it out. Incase anyone else is looking. Amazing what you can find in the manual. -- Djmask ------------------------------------------------------------------------ Djmask's Profile: http://www.excelforum.com/member.php...o&userid=24414 View this thread: http://www.excelforum.com/showthread...hreadid=396599 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
In VBA set Slection.AutoFilter show all
Thanks Norman. That is actually what I needed to do I just didn't realize it at the time. -- Djmask ------------------------------------------------------------------------ Djmask's Profile: http://www.excelforum.com/member.php...o&userid=24414 View this thread: http://www.excelforum.com/showthread...hreadid=396599 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro / Autofilter / Show All Data | Excel Discussion (Misc queries) | |||
| autofilter show all data | Excel Discussion (Misc queries) | |||
| Debit/credit amount Slection How? | Excel Discussion (Misc queries) | |||
| Autofilter- show dates differently | Excel Discussion (Misc queries) | |||
| *difficult* importing slection from a txt file to new column | Excel Programming | |||
Linear Mode
