Thread: Naming an Array
View Single Post
  #1   Report Post  
Iain
 
Posts: n/a
Default Naming an Array

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!