I have a large Excel database which is spread across multiple folders
(folderName), each folder containg multiple workbooks (wbName), each
workbook containing multiple worksheets (wsName)., each worksheet
containing multiple Rows ( rowNumbers) and Columns ( ColumnNames)

If I specify all the Names then I get a specific cell value.

CellValue = (folderName, wbName, wsName). Values(RowName or RowNumber,
ColumnName).

I currently create an array from the Excel database using this stucture
to manipulate the data, but I assign number values to each of the names
so I can reference them in an array type ie

CellCalue = SpecialArray (1,2,3). Value (4,5)

Every time the program sees a set of Name(s) it has to search for it's
equivalent number to plug in above to derive the cell value.I am trying
to avoid doing this. Is there anyway I can dimension a variable Name
and assign it a number value so that whenever that Name is used I can
use its number value in above function? Or is there another way use
Name references to extract data from an array?

Thank you for any ideas.

K