I have written code to find "total" in column A and to clear the data below total in Cols A to O
The code only clears one row of data
Your assistance in this regard is most appreciated
The code only clears one row of data
Your assistance in this regard is most appreciated
Code:
Sub Clear_Data_Below_Total()
finalrow = Range("A65536").End(xlUp).Row
For I = finalrow To 1 Step -1
Cells(finalrow, I).Resize(10, 15).ClearContents
Next I
End Sub