• Much thanks to Chip Pearson in the microsoft.public.scripting.vbscript news group for posting the links to http://www.cpearson.com/zips/xlconsts.zip and

    http://www.cpearson.com/zips/xlobjects.zip

    The numeric translations for my variables was containted within.

    The correct line should read as follows:

    wkbnew.worksheets(1).range(rowcol).validation.add 3, 1, 1, "=$A$1:$A$4"

    Peace Out!

    Regards,
    Matt