It sounds like your macro may be selecting each of the cells. It also sounds like it does not quite know when to stop. This can definitely be sped up. Can you post the code you have so far or a sample book with the desired result.