Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event validating two ranges with dates
Hi,
I would like to validate two ranges with dates using Worksheet_Change event. The date in the first column should be always greater than a corresponding entry on the same row of the next column. Data Validation is not an option since both columns will be pasted from another source. Is it possible to do with Intersect (rng1, rng2) or I need to loop thru ? Also, I wonder how I could count the “wrong” dates in the second column and have a message saying for example something like “Column B has 20 cells with incorrect dates?” Thanks much, Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Outlook Calendar event from dates in excel | Excel Discussion (Misc queries) | |||
sumproduct - validating codes & dates | Excel Worksheet Functions | |||
Referring to Ranges in Change-Event Macro? | Excel Discussion (Misc queries) | |||
formula needed to track dates event happened | Excel Worksheet Functions | |||
Validating Dates Entered | Excel Discussion (Misc queries) |