Hi

When you are in the sheet, press ALT F11. This will bring up the VBE. Go Insert, Module, paste in the code. Then go back to the spreadsheet, press ALT F8, select the macro name, then run.

HTH

rylo