I've had some "issues" with conditional formatting before when I've tried tocopy and paste using VBA. Have you any idea if that is still the caseplease?