I suppose, you are talking about Ken's Code http://www.excelguru.ca/content.php?...-Via-Groupwise.
Have you set a reference to the groupwise type library? You can do that by opening the Excel VBA Editor,
select "Tools" in the main menue bar, then "References" and the check the appropriate type library in
Best Regards :-)