I'm not exactly sure what you're asking, but....You can remove highlighting using the following line:Selection.Interior.ColorIndex = xlNone