can i create an array on an workbook which can be accessed by all worksheets on that workbook ?
L Luis Neves Feb 13, 2004 #1 can i create an array on an workbook which can be accessed by all worksheets on that workbook ?
A Alan Beban Feb 13, 2004 #2 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
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
