Thread: Date Removal
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Grunt Grunt is offline
external usenet poster
 
Posts: 5
Default Date Removal

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?