Global range name
"msa165" wrote in message
...
Is there a way to set a global range name that can used across all of my
spreadsheets? I was thinking I could set a range in an add-in, but once
my
file is converted to an add-in, I wasn't sure how to access the worksheet
if
I needed to make changes. Basically, what I am looking to do is to have a
range of holidays that I can then reference whenever I am working on
Excel.
An example function would be =workday(today(),30,Holidays), where holidays
is
the golbal range name. While I can probably set the holidays now going
forward for a while, I would like to be able to view and change them
fairly
easily if necessary.
|