I appreciate the assistance however I received the following error:

Run-time error '1004'
Application-defined or object defined error

the VB script editor highlighted this row

Set rng = Worksheets("Project").Range("A2", Cells(2, cLastCol))

Thoughts

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