Hi all,
Hoping someone can help with me with a small bit of code. I'm new to VBA and am struggling to make a simple loop work. I want to start with the first day of the current month (will be run fresh each month) and I have done this fine using dateserial function. Essentially I want to repeat each day in a given month 3 times and loop all the way to end of the month. So would read like:
01/06/2020
01/06/2020
01/06/2020
02/06/2020
02/06/2020
02/06/2020 and so on until the 30th.
I'm getting stuck between just repeating the code and looping.
Any help welcome.
Hoping someone can help with me with a small bit of code. I'm new to VBA and am struggling to make a simple loop work. I want to start with the first day of the current month (will be run fresh each month) and I have done this fine using dateserial function. Essentially I want to repeat each day in a given month 3 times and loop all the way to end of the month. So would read like:
01/06/2020
01/06/2020
01/06/2020
02/06/2020
02/06/2020
02/06/2020 and so on until the 30th.
I'm getting stuck between just repeating the code and looping.
Any help welcome.