Attached s-sheet has a date in it (D6) that I am trying to run an if < Now() on and it is always coming back false when it is true? Using a VBA command, how do I reformat that cell so it is a date? and returns a True?
Actually what I am trying to do is kill every row until the next date in column D if < now(). When the next date is reached check that date to and do it again if true and still < now() , until a false value is reached.
Another issue I am coming across is the empty cell under the date have spaces in it, so I cannot use while(not(isempty... how can I delete the rows when they are not really empty or blank?
Could I get some help writing this in VBA? Thanks.