Hi,

a happy new year to everyone! May it bring you all you wish and hope for and/or what is best for you!

I have a challenge - I'm confident I would be able to come up with some solution on my own, but I wonder if there is some "Best_practice" or something for this:

Most macros I have written so far are used in the morning of any given work_day in various departments and they usually process data that was gathered in some list or other on the previous work_day.

=> In one dpt., there was an error today, so they reverted to doing it manually for today. Not a big thing, but then it would probably not be a big thing to avoid that need.

I haven't yet looked into that error, but my assumption is that the macro just did what it is supposed to do - it looked for the data carrying the date_stamp of the last working_day before today which happens to be last Friday like every monday - only last Friday was a public holiday, so there cannot have been any data.

=> So I'll have to implement some little routine - m.o.l. only a MATCH() function - to process a list of public holidays for the current year and whenever the last
      working_day was a holiday, then the macro should go back one day more.

Now, as this will be needed in all the macros I have written so far and in every macro I'm going to write, it would be the most elegant and easy way to put this into a subscript - but since it's not a lot of code that I need and I'll have to implement at least some little element (like a variable) in every single script, it doesn't make much of a difference.

Do you know any agreed-on best_practice for this kind of thing?

Thanks a lot!

Best regards,

Officer_Bierschnitt