Skip first row in an Excel routine
Posted on 2014-02-04
The first row in my worksheet contains headers, so I don't want to apply the logic below to it. How do I modify the code to skip the first row? Thanks.
For Each oCell In Intersect(Range("B:Z"), ActiveSheet.UsedRange)
'Set value of blank cells to 0
If oCell.Value = "" Then
oCell.Value = 0