VBA to find and replace border colours

Will the cells with borders on them also have values/formulas in them? I'm not sure there's a way to look at cell borders of empty cells without looking at every single cell on the sheet, which obviously you don't want to do.

But I hope someone can prove me wrong!

This was fun, first time I can remember working with borders in VBA. So thanks.

There's a lot of looping here, but I didn't really see any other way to accomplish this. Maybe someone else has more elegant code.

Also, I hope it you intention to turn all those red borders into borders that look like the default cell borders? Because that's what that replacement thin grey line looks like.

Please Login or Register  to view this content.

Post an example workbook then, because it works on my test sheet with the descriptions you've given.

yes, they've all got formulas in them

Well, your example doesn't have formulas. Put a formula in a cell and the code will remove the borders. So... are you now saying the cells won't have formulas in them? What will be in them?