Hi,
I am using the following code which was very kindly provided from this site.
I would like to amend it to exclude weekends (Saturday & Sunday) as I have now removed these dates from my sheet
Thanks
Please Login or Register to view this content.
Kevin
How about this.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thank you for looking......It dosent appear to be working?
I have simply replaced the entire code with the code suggested, is that correct
I get no error message either
I think the issue may be thatis greater the 5, then what?Please Login or Register to view this content.
Last edited by Excelski; 12-09-2018 at 07:08 AM. Reason: Just guessing!!
Weekday returns the daynumber in a week of a certain date. Monday = 1 to Friday = 5.
The function Weekday is now instructed to start on Monday so if Date - 1 returns 6 or 7 means it's a weekend day.
In that case we have to do nothing.
Okay, thanks. Thinking about it a bit more this scenario will only occur when the sheet is opened on a Monday, so instead of doing nothing can go to Monday instead?
How about this then.
Please Login or Register to view this content.
Great...works perfectly, thanks!
Kevin
Glad to help and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks