Please see Re: Finding out Excel 'variables'.
HTH,
In reply to Re: Excel enum lists by planetscape in thread Excel enum lists by merrymonk