| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy rows automatically
I'm using the following code to copy rows automatically based on certain
criteria within the code. How can I set it up so that one of my selected criterias is always using less than the current date? This is the code line I'm looking to change: rng.AutoFilter Field:=15, Criteria1:="=01/01/2000", Operator:=xlAnd, Criteria2:="<=07/28/2008" ' Right now I have criteria2 set to <=07/28/2008 but I want this to be less than todays date. I tried <Today() but that didn't work. How would this work? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically copy rows based on criteria | Excel Discussion (Misc queries) | |||
| Macro to automatically add rows and copy formulas | Excel Discussion (Misc queries) | |||
| Automatically copy formulas/functions to inserted rows. | Excel Worksheet Functions | |||
| Copy Rows to another Sheet Automatically | Excel Worksheet Functions | |||
| How to copy values in various rows automatically | Excel Discussion (Misc queries) | |||
Threaded Mode
