Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Establishing a date range help with macro
Hi, I have a column that has dates of transactions, and I'm writing a
macro that asks a user for a range and then performs a task on all rows where the dates are within the range. The problem I'm having is that I don'tk now how to write a robust search where even if the date is not specifically in the range, it will start at the next date. In other words, I don't want to step through the entire database, and I want to perform my action on just a specific date range, and I can't just search for the date because that specific day may not have a transaction record. Any idea on how to approach this?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Establishing a Time Window | Excel Worksheet Functions | |||
Establishing Annual Leave Entitlement | Excel Discussion (Misc queries) | |||
Re-establishing Links | Excel Discussion (Misc queries) | |||
Re-establishing Links | Links and Linking in Excel | |||
How do I set a date range for conditional formatting in a macro? | Excel Worksheet Functions |