oakman,

That 'subscript out of range' message is because the worksheet

Worksheets(Units_Sht_Name)

cannot be found. Check that all the names on your Input sheet have
corresponding named sheet.

If. for example your Input sheet had the names Smith, Jones and Brow
but there was no sheet named "Brown" in the workbook and the word Prin
appeared beside Brown in the Input sheet - runnung the macro woul
generate the 'subscript out of range' message.

Regards

Seamu

--
Message posted from http://www.ExcelForum.com