Hi a.collister

Welcome to the Forum!!

Code does not error in Excel 2003 or Excel 2007
Run Time Error in Excel 2010...no clue why...