Hello, I have a loop that I am running but need a little modification to it.
I was wondering for this line of code:![]()
Sub ErrorFinder() Dim i As Integer i = 0 rowz = Range("A1").Offset(Rows.Count - 1, 0).End(xlUp).Row For Each Rng In Range("A1" & rowz) If Rng.Value = "" Then Rng.Interior.ColorIndex = 3 i = i + 1 Else: Rng.Interior.ColorIndex = 0 End If End Sub
Is there a way I can skip the first row and still run the loop?![]()
rowz = Range("A1").Offset(Rows.Count - 1, 0).End(xlUp).Row
Bookmarks