The macro is sound as I've used it for his task in the past. Before we can discount it you should see it actually working.

Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook. I'll see if I can spot why your having trouble with it.