Hi all, new to VBA and about to fully automate my first report, thank to videos, books and mrexcel.
Not sure how to approach this last one... so for column Q, fill blanks with consecutive end-of-month date, same range as column W.
Result (for cells below 31/10/2020):
30/11/2020
31/12/2020
31/01/2021
etc
Found this thread, but dates are fixed, and in my case they may vary each report:
Cheers
Not sure how to approach this last one... so for column Q, fill blanks with consecutive end-of-month date, same range as column W.
Result (for cells below 31/10/2020):
30/11/2020
31/12/2020
31/01/2021
etc
Found this thread, but dates are fixed, and in my case they may vary each report:
VBA Macro to Return Consecutive Month-ends
This is my first ever post on this website. I need help on some VBA code that will put 31/07/00 into cell “B2” and then each month-end date down the column and stop at 31/11/2010 in cell “B126” (ie.
stackoverflow.com
Cheers