| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter on today...how possible?
Hi all,
In the below VBA code I want to filter on Today. To do so I place today's date in a cell and copied that with the filtering. Unfortunately in the code 30/03/07 is places. Can somebody tell me how I could fix this? Thanks in advance, Wietse VBA code: Range("F26").Select ActiveCell.FormulaR1C1 = "=TODAY()" Range("B28:F28").Select Range(Selection, Selection.End(xlDown)).Select Range("B28:F300").Select Selection.AutoFilter ActiveWindow.SmallScroll Down:=-12 Range("F26").Select Selection.Copy Selection.AutoFilter Field:=5, Criteria1:="<30/03/07", Operator:=xlAnd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to filter for Dates prior to Today | Excel Discussion (Misc queries) | |||
| filter using today() | Excel Discussion (Misc queries) | |||
| IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
|
=IF(OR(TODAY() |
Excel Discussion (Misc queries) | |||
Threaded Mode
