Jagwarman
asked on
Excel 2010 delete rows with a dates less than last working day
Can an expert provide me with VBA code that will delete rows with a dates less than last working day
i.e. if today is 07-Mar-14 ...Cells in column A dated 05-Mar-14 or less delete Keep only 06-Mar-14
On Monday 10-Mar-14 keep only 07-Mar-14
Thanks
i.e. if today is 07-Mar-14 ...Cells in column A dated 05-Mar-14 or less delete Keep only 06-Mar-14
On Monday 10-Mar-14 keep only 07-Mar-14
Thanks
ASKER
Hi Rgonzo1971 I am never sure what Dims to use?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Brilliant thanks
pls try
Open in new window
Regards