Thank you for taking the time to try to help me. Unfortunately I don't know really know how to use it. How do I incorporate it into a worksheet. I have saved it. I have also tried to open it in order to study it and perhaps learn a bit about how to build a macro. When I try to open it, excel opens with a blank screen and when |I click on View Macro I get a message to say that excel has stopped working and windows has found a problem.Have I done something wrong.