Trying to copy a sheet every seven days (or when the user next logs on). Sub is activated by a user pressing a command button. Date of last copy determined by cell c23 on sheet 1.
Everything works except the "every seven days" element of the sub. It still runs when the value in c24 is less than seven days old. been playing around with various combinations of > < + and -. None seem to work, starting to think i've done something wrong in the formatting of the date?
Any help would be appreciated as always.
Thanks all!Please Login or Register to view this content.
Bookmarks