[Solved] Excel VBA – Finding the beginning and end of coloured rows
How’s this? Sub findColoredRows() Dim startCol As Integer, endCol As Integer, o As Integer Dim ws As Worksheet Dim i As Integer, k As Integer Dim startRow As Long, endRow As Long Dim cellColor As String, noColor As String Dim cel As Range noColor = -4142 ‘ this is the color index of NO coloring … Read more