I have built several arrays (excel 2003). When creating the array I highlight the cells for the array and put a name in the name box to use for a vlookup function.
It seems after I make the array I can click a different cell and then come back and hi-lite the array cells and the name re-appears in the name box, but after I make changes to other parts of the worksheet and go back to the array the name box no longer displays the array name.
Is there a way to always display the name when hi-liting the array cells?
I've attached a workbook with an array in worksheet CA_RR1 cells A28:B39 - WHEN i select those cells it just shows A28 in the name box.
Thanks for your help.
Bookmarks