
snb, who wrote the detailed piece on dictionaries, has applied the same rigor to arrays. I knew there would be something in there that I didn’t know (there was plenty). Under the section about identifying the existence of an item in an array, you can use a defined name: 6.2.2.3 The Excel-object ‘Names’ Assign the […]