yes, I use "application.screenupdating = false" but always end with"application.screenupdating = true".Are you saying I need to fash the screen to update the sheet?ie"application.screenupdating = false""application.screenupdating = true"