ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Find cells without borders (https://www.excelbanter.com/excel-discussion-misc-queries/177447-find-cells-without-borders.html)

Marc C

Find cells without borders
 
I need VBA code that looks for all cells in a range of a worksheet that do
not have a left, right, top, and bottom border. That is, one of these four
borders is missing. Once the macro finds a cell with a missing border, I
would like the macro to add a red thin border to the missing border location
of the cell.


All times are GMT +1. The time now is 03:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com