Excel VBA – Count Cells with Borders
Hello, I’m looking to create 3 new functions via Excel VBA which solve the following purposes:
1. Count cells that are completely surrounded by borders (Top, bottom, left, and right)
2. Count cells that are completely surrounded by borders, with text in the cell.
3. Count cells that are completely surrounded by borders (Top, bottom, left, and right) that are a certain color (red)
I also need the formula for black and blue, but I’m assuming I can change the “Red” to a different color after.
Thanks for help on any of these formulas. I have very little experience with VBA, and all of my research and code I have written do not work.
Hello, I’m looking to create 3 new functions via Excel VBA which solve the following purposes:1. Count cells that are completely surrounded by borders (Top, bottom, left, and right) 2. Count cells that are completely surrounded by borders, with text in the cell. 3. Count cells that are completely surrounded by borders (Top, bottom, left, and right) that are a certain color (red)I also need the formula for black and blue, but I’m assuming I can change the “Red” to a different color after. Thanks for help on any of these formulas. I have very little experience with VBA, and all of my research and code I have written do not work. Read More