The change to the Case statements I suggested can't affect the application of the cell borders. It seems you changed more than what I suggested.