Hello
Working on macro in which I have a start date and end date. I used the following code to fill only weekdays but the fill series does not inlcude Friday if that is the end date .
Working on macro in which I have a start date and end date. I used the following code to fill only weekdays but the fill series does not inlcude Friday if that is the end date .
VBA Code:
sh9 = ws1.Range("U" & xLoop).Value 'start date
sh10 = ws1.Range("W" & xLoop).Value 'end date
With ws2.Range("BA" & lr2)
.Value = DateValue(sh9) + (Sh14)
.DataSeries Rowcol:=xlColumns, Type:=xlChronological, Date:=xlWeekday, Step:=1, Stop:=DateValue(sh10 + 1), Trend:=False
End With