Interesting because when I placed it in your workbook, it worked for me. Did you place the code in the regular module or in the worksheet event? This would make a big difference. To place in a worksheet event, open the VBE. In the left window click on the worksheet you have the data in. A window should open in the right side of your screen. Copy my code and paste it into that new window. Save and close. Now try it.