Matthew Balch wrote:
Dim markets As New Scripting.Dictionary
The problem being the second line of code. Dim markets As New.Scripting
Dictionary. Problem being 'Used-defined type not defined'.

user defined types are not passed along in the code - i believe they
are in the workbook itself. try searching the newsgroup for "user
defined types" to learn more about them & maybe you will find a way to
change it.
i haven't used user defined types yet - i stick with "range", "string",
"integer", etc.
susan