Hi AB33

I copied the code from the xls workbook and pasted it to the xlsm workbook. I believe I was running the code from my active workbook.

Both Kbkumar and Winon tried the code with a xlsm workbook and it worked well. I don't know why it didn't work on mine. I'll try again and when I'm back to work next Friday. I'm using excel 2003 at home and couldn't open a xlsm file.

Thanks so much for the reply!