I can't get this to run?! I am probably doing something silly. If I have saved my workbook as a macro enabled workbook and added the code as a new module. I am then pressing F5 to run the code, but it pops up a prompt asking me what macro to run, and the macro I added in (your code) does not show in the list?