Function layout

  • Thread starter Thread starter Jesse
  • Start date Start date
J

Jesse

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)
 
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
 
Back
Top