skywriter, I agree that excessive use of CD can start to slow your file down. If the data range is far larger than the sample, then VBA would be the go. However, you have included both into 1 macro, so that would be a better option