I would be more inclined to use a collection as opposed to an array...

Public colObjects As Collection

Sub PopulateCollection()
Set colObjects = New Collection

colObjects.Add Sheet1, "MySheet"
colObjects.Add Range("A1:B2"), "MyRange"

MsgBox colObjects("MySheet").Name
MsgBox colObjects("MyRange").Address
End Sub
--
HTH...

Jim Thomlinson


"pinkfloydfan" wrote:

Hi there

In order to keep an object in memory with a know reference point, I
typically store it in an element of a public array. Thus, the element
number it is stored in becomes a reference point to the object and
using this number I can access that specific object's methods through
other UDFs.

The problem with this though is that it is not particularly neat in
that referencing an object in memory via a number offers no
description to what the object is. I would much rather be able to
attach a (user-defined) label to the object and use that label as a
reference point. However, my problem then becomes how to set a
pointer from that label to the array element the object is stored in.

Does anybody have any ideas that I might try to achieve this labelling
process?

Thanks very much
Lloyd