Can you post a dummy workbook? I have a macro that does something a little bit more complicated, but might be able to ajust it to fit your needs... No promises but might be worth a shot