I'm creating a function that I and my co-workers will use extensively. The
company I work for has over 100 location and 6-8 different ways of
referencing a location, four different number designations, three names and
combinations of the above.

The function will just translate from one type of name to another so there
will only be two arguments. Personally I use a vlookup with a table with
all the different names in many columns but many of my co-workers have a
little difficulty understanding the vlookup.

My question is whether it would make better sense to load the location info
into an array with about 1500 items or to leave them in a sheet in the
add-in and look them up from there?

Jesse

Jesse,

Personally, I would always leave them in a sheet, in a nice, simple,
formatted manner. It's much easier to look at them then. This is how I build
Commandbars by building such a table in a worksheet, much easier to maintain
and know what my data relates to.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jesse" wrote in message
news:SYdBb.28931$d35.18752@edtnps84...
I'm creating a function that I and my co-workers will use extensively.
The
company I work for has over 100 location and 6-8 different ways of
referencing a location, four different number designations, three names
and
combinations of the above.

The function will just translate from one type of name to another so there
will only be two arguments. Personally I use a vlookup with a table with
all the different names in many columns but many of my co-workers have a
little difficulty understanding the vlookup.

My question is whether it would make better sense to load the location
info
into an array with about 1500 items or to leave them in a sheet in the
add-in and look them up from there?

Jesse

Thanks for the advise Bob, I wasn't sure if I would gain enough in
performance to make it worth making an array for it.

Jesse


"Bob Phillips" wrote in message
...
Jesse,

Personally, I would always leave them in a sheet, in a nice, simple,
formatted manner. It's much easier to look at them then. This is how I
build
Commandbars by building such a table in a worksheet, much easier to
maintain
and know what my data relates to.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jesse" wrote in message
news:SYdBb.28931$d35.18752@edtnps84...
I'm creating a function that I and my co-workers will use extensively.
The
company I work for has over 100 location and 6-8 different ways of
referencing a location, four different number designations, three names
and
combinations of the above.

The function will just translate from one type of name to another so
there
will only be two arguments. Personally I use a vlookup with a table
with
all the different names in many columns but many of my co-workers have a
little difficulty understanding the vlookup.

My question is whether it would make better sense to load the location
info
into an array with about 1500 items or to leave them in a sheet in the
add-in and look them up from there?

Jesse