Re: $$Excel-Macros$$ VBA code to delete all dates before last week

2010-05-07 Thread Sundarvelan N
Hi Siti, Thank you very much Thanks, Sundarvelan On Fri, May 7, 2010 at 1:44 PM, siti Vi wrote: > Assuming that : > * YOUR LIST OF DATE are in a Range > * "to delete" means to clear the content of a cell containing Date > data > > Sub DoSomething() > Dim MyRange as Range, Xel As Range > Di

Re: $$Excel-Macros$$ VBA code to delete all dates before last week

2010-05-07 Thread siti Vi
Assuming that : * YOUR LIST OF DATE are in a Range * "to delete" means to clear the content of a cell containing Date data Sub DoSomething() Dim MyRange as Range, Xel As Range Dim LastWeekWednesday As Date '--Please edit the code for your Range Set MyRange = Sheets("Bla").Range("A2:A65