Martin, that is brilliant - is there any way I can get this code to work on a range of worksheets or will i just need to have this code on every Worksheet for it to work!?