Thanks when I paste the macro into my personal.xlsb, and run the macro from within excel, nothing happens. It appears some kind of button function is executing it.