It worked on your test file. Like I said, the code should be in the code module. It should NOT be in the sheet code module. When you copy a sheet, the code DOESN'T get copied over and over again.