Hi guys Im hoping someone could help me out a little, Ive been working on a huge custom filter which has 3 slight variations but they are all basically the same code
I thought everything were working fine untill now when Ive tested it a little more.
- Running the macro first time always produce the correct result.
(this subs removes past dates based on values in col B)
But If I am to run this sub for a 2nd time it removes more rows and outside of what I thought were the criteria . I'm not sure whats happening. I thought maybe the Lastrow var or something gets messed up but that's not the case.
i also tried adding this at the end but didnt help
Anyone know what might be the problem. Also Obviously I know its necessary to run this macro more then once but I would Like to run a quite similar macro after this one but its not working as I would expect ??
any help would be much appreciated..
frederik
Bookmarks