Your code is near to be acceptable but
you did not use the appropriate cell property according to the date data type
neither the appropriate variable data type
- must be Variant (like C but not R) as MATCH worksheet function can return an error instead of an integer -
and 'cause this error may raise you forgot to check the result of this function …
Your procedure revamped according to the above and the cells validation :
► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄
Bookmarks