| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filter using today()
i'd like to autofilter using today() but can't seem to remember the code and
=today() does not work in the customization option. i know visual basic, but i'm unable to get it to work there either. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filter using today()
in auto filter select today's date "carly" wrote: i'd like to autofilter using today() but can't seem to remember the code and =today() does not work in the customization option. i know visual basic, but i'm unable to get it to work there either. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filter using today()
VBA
On Error Resume Next Columns("H:H").AutoFilter On Error GoTo 0 Columns("H:H").AutoFilter field:=1, Criteria1:=Format(Date, Range("H2").NumberFormat) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "carly" wrote in message ... i'd like to autofilter using today() but can't seem to remember the code and =today() does not work in the customization option. i know visual basic, but i'm unable to get it to work there either. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
|
=IF(OR(TODAY() |
Excel Discussion (Misc queries) | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Linear Mode
