I am trying to make this macro delete blank rows and skip any rows that has subtotal in the line.
Dim lr As Long
lr = Range("c" & Rows.Count).End(xlUp).Row
Dim i As Long
For i = lr To 2 Step -1 'loops from last row to row 2
If Value("G") = "subtotals" Then Skip 'This like is the code that is supposed to skip
If Range("c" & i) = "" Then Range("c" & i).EntireRow.Delete