Hi there!
My spreadsheet has a long list of months in column X like:
Jan/20
mar/20
jul/20
aug/20
dec/20
I need a macro that goes from A1 to usedrange.rows.count, and list the missing months.
In the above example the result should be: (msgbox):
"feb/20, apr/20 to jun/20, sep/20 to nov/20"
Need help to do this.
Thanks.
My spreadsheet has a long list of months in column X like:
Jan/20
mar/20
jul/20
aug/20
dec/20
I need a macro that goes from A1 to usedrange.rows.count, and list the missing months.
In the above example the result should be: (msgbox):
"feb/20, apr/20 to jun/20, sep/20 to nov/20"
Need help to do this.
Thanks.