VBA arrays manage data using numerical "index numbers," such as myArray(0). However, in practical work, you often want to manage data using more meaningful strings rather than numbers—for example, ...

So, I am writing an application in Excel2000 and VBA. I am using Autofilter to go through a bunch of raw data in a worksheet, filter it out, and copy it to a new sheet. For example, I have a sheet ...