can i create an array on an workbook which can be accessed by all
worksheets on that workbook ?

Insert|Name|Define, type in myArray, in the Refers to block type in
{"Jones","Smith","Doe","Roe"}, click OK

Now if you array enter myArray into a 4-cell row on any worksheet it
will return the elements of the array.

If you use semicolons instead of commas in the Refers to block, you
should array enter myArray into a 4-cell column.

Alan Beban

Luis Neves wrote:
can i create an array on an workbook which can be accessed by all
worksheets on that workbook ?