Thanks I have copied this to a module, but when I close it and look for macros for the sheet, there are none shown?

Am I doing something wrong?

I am inserting a module into sheet 1 and it shows up as a module, I then close this and go back to the sheet.

Regards

Graham