Thread: delete entirerow if date more than 12months old
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
flow23
 
Posts: n/a
Default delete entirerow if date more than 12months old
I want to delete the entire row if the date in column B (yyyymm format e.g.
200605 for may 2006) is more than 12 months old.

how do I write the if statement in the macro?

Reply With QuoteReply With Quote