voorbeeld-2-july-updated.xlsHi Kreppie,
You can find some code below.
I have attached your updated file as well.
So the function / macro "deleteColumns" will delete the columns, you cannot restore that. So in case you have the next month, you need to update your sheet again.
Maybe more convienent to just hide/unhide the columns? Then you can use the other macro "hideUnhideColumns"
If you check my returned workbook, the "thisWorkbook" object refers to this macro on startup. With other words: If you open your file, it checks what columns need to be displayed.
Problem solved?
Bookmarks