Ahh, I feared as much. Essentially I have a long list of stock codes that I would like highlighted when I run a macro on the excel reorder report.