Thanks Joel for all your help - very much appreciated. I am however
encountering a Run Time Error '91' - Object variable or With block
variable not set. This occurs at the following line of code:

c.EntireRow.Copy _
Destination:=newbk_sht.Rows(NewbkRowCount)

Could you please advise on how to set the Object variable or With block
variable?


Kind regards,

Chris.

*** Sent via Developersdex http://www.developersdex.com ***