Title is a bit confusing but I honestly don't know how to do what I want it to do.
We have a shared folder and I'm programming an excel addin for my colleagues so it's easier to update it in the future. Part of the function that I'm creating will calculate the amount of labor days between two dates, and it has to exclude holidays. Can I:
- Create a table in the workbook that I'm using to create the addins and have my macro reference it. Would that slow the function too much? Can everybody access it regardless of how their shared folder is named or everybody must have the same name for shared folder?
- Create an array with every date that will be a holiday, and just leave it in the module?
Which of those two will work better? Sorry if its hard to understand, I haven't been writing in English often so I'm a little rusty.
Bookmarks