I have an enum
Enum myEnum
OBS_COL = 1
LOC_COL = 2
ITEM_COL = 3
DESC_COL = 4
end Enum

I want to iterate through it, but [Enum].getvalues is not available in Excel 2002 VBA. Is there a way to traverse an Enum?

Otherwise I can put my name/value pairs in a range and loop through the range. Note, the numbers may not be in order, i.e. may be 10,5,7,6

Is there a better way?

Thanks.