for the dates, just use like this without the formatting stuff.
Criteria1:=">=" & OKSheet.Range("C2"), Operator:=xlAnd,...
Let me see if I understand...
If we are talking 2018, then the first working day is Tuesday, 2nd January (assuming that New Years Day is a holiday)....
I am looking for some help on creating a formula that will return the first day of each week in a quarter based on the current year and eliminating holidays....
mossdrive Yesterday, 09:06 PMHi I am trying to copy and paste the value in the Analysis tab based on Analysis tab multiple criteria at Cell C2, D2, C3, D3, C4, D4, C5 & D5. I...
Rahul Malhotra Yesterday, 05:42 PM
Is there way to report or manage the number of .Add lines in a Scripting.Dictionary?
In this function, I was able to have 3,000 .Add lines, but I don't know
alex20850 Today, 03:05 AMhow to determine the limit beforehand or if there is a way to increase...