the code is fine since it works in 2010 for me. can you post the workbook-just that sheet and the code necessary