Hi I managed to set up my original vba using your advice on a previous forum and thought maybe you would be able to help with my query now. Thanks Gemma http://www.excelforum.com/excel-prog...ther-cell.html