date in A3 is later than in A2.
Plse supply code.
date in A3 is later than in A2.
Plse supply code.
You could use Data Validation with a Custom type and a formula of
=SUMPRODUCT(--($A$2:$A2>=$A4))=0
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thank you for your formula.Originally Posted by xld
As I want to add code to my macro.
vba code rather than Data Validation, plse
Then we would need to see what your code does to know how to do a test.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
If date in A3 is later than in A2 or If dates in A: alreagy sorted,
go to A6 and fill-down from A6 to A10
asdzxc, you have a habit of using the Quote tags consistently. Only quote if required and simply type your questions, queries or comments without the quote please.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Posting Permissions
Reply With Quote
