Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Where is the bug in my array? | Excel Discussion (Misc queries) | |||
Transpose into a _working_ transposed array | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |