I am using the below code for content banding whenever a value changes in column B
Can anybody please amend the code to look at visible rows. Like when data is filtered.
Dim r As Long, val As Long, c As Long
r = 1
val = ActiveSheet.Cells(r, 2).Value
c = 34...