I currently have code that allows me to create hyperlinked formulas and open the pdf's based on part numbers, but some of the part numbers links do not exist. I was wondering if instead of on error resume next, is there a way to color in the cell that Errors and resume at the same time? It can...