G
Guest
Hello,
I have a report that contains dates in column B, these dates can be
repeated many times and span everyday of the year. I wish to delete all rows
that contain a Saturday date in column B.
Is there a way to do this in vba without having to use the exact Saturday
Date in the code. I saw a Function called Weekday, which used the value 7 to
represent Saturdays. My vba skills are weak and I am unable to apply this
function properly.
Any help?
I have a report that contains dates in column B, these dates can be
repeated many times and span everyday of the year. I wish to delete all rows
that contain a Saturday date in column B.
Is there a way to do this in vba without having to use the exact Saturday
Date in the code. I saw a Function called Weekday, which used the value 7 to
represent Saturdays. My vba skills are weak and I am unable to apply this
function properly.
Any help?