Naming an Array

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

I have built an interactive menu system in Excel that is based around moving
a series of Text boxes and objects in front/behind an opaque square using
simple macros.

One problem with this method is that when I need to update the menu by
either adding or removing an item, I have to manually change the array
selection in the macro, so that the list of objects to move includes (or
doesn't as the case may be) the new or removed object.

Is there a way to apply a name to an array that I want to select so I can
simply change the definition of the group to update the objects that are
moved, much like what can be done with the "Insert|Name|Define" approach for
cells?

Thanks for your help!
.

Relevant Pages

  • Re: Extremly fast dinamic array implementation
    ... It's only an array, for pity's ... Macros don't have a speed. ... foo.c:50: warning: assignment discards qualifiers from pointer target type ...
    (comp.lang.c)
  • Re: Standard library macros
    ... standard library *must* be implemented as macros instead of functions, ... I believe the reason they *must* be implemented as macros is because ... by introducing a better alternative (inline functions). ... type_is_array(x) returns 1 if x is an array type, ...
    (comp.lang.c)
  • Re: Importing data from Access to Excel, but I need to vary the table from Access
    ... .CommandText = Array(_ ... .PreserveFormatting = True ... .RefreshStyle = xlInsertDeleteCells ... It takes too much time to manually change the ...
    (microsoft.public.excel.programming)
  • Re: Using Arrays In Macro To Find And Replace ?? Help.
    ... That's how the array works - each word is processd individually. ... macros searches pen in the whole doc one by one and replaces it. ... There are different types of pens. ... Dim sRep As VbMsgBoxResult ...
    (microsoft.public.word.vba.general)
  • Re: How powerful macros are?
    ... > Currently my knowledge of macros is extremely ... Lisp macros are not about ... internal implementation as the C-style notation. ... about an array, an element of that array, and a value to store in that ...
    (comp.lang.lisp)