Hello,
I have one new issue.
When I'm trying to change to cell value I've got Global Error.
to something like this:Const FirstDay As Date = "2017-12-31"
Thanks in advanceddim FirstDay as string FirstDay = Sheets("DATA").Range("J3").NumberFormat = "yyyy-mm-dd"
ps
I change FirstDay as date and it's working.