ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   exclude international and national holidays into conbobox... (https://www.excelbanter.com/excel-programming/350209-exclude-international-national-holidays-into-conbobox.html)

sal21[_97_]

exclude international and national holidays into conbobox...
 

is possible in this rouitine (Private Sub ResetDate()) exlude the days
into range sheet DATE column W (range W2:W13)...
In effect i have maked the exlusion of saturday and Sunday, but have
difficult to exclude the date into range of column W...
In effect i would want only the effective work days dates.
Tks.


+-------------------------------------------------------------------+
|Filename: TEST_DATE.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4214 |
+-------------------------------------------------------------------+

--
sal21


------------------------------------------------------------------------
sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040
View this thread: http://www.excelforum.com/showthread...hreadid=500597



All times are GMT +1. The time now is 10:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com