FABULOUS! Thanks again for all the help!!!


"Norman Jones" wrote:

Hi Kelli,

Change:

SH.Range(FirstCell, LastCell).Copy Destination:=destRng


to

SH.Range(FirstCell, LastCell).EntireRow.Copy _
Destination:=destRng

---
Regards,
Norman