Hi,
I'm searching a quickly way to clear a column starting at the 7th row until the end of the data in row 13.
Here is my macro, who's working but too slow (20 sec. to clear 10 rows !) :
Any idea will be great !
Thank you
Loadlucas
I'm searching a quickly way to clear a column starting at the 7th row until the end of the data in row 13.
Here is my macro, who's working but too slow (20 sec. to clear 10 rows !) :
VBA Code:
Sub ClearCol_N()
x = ActiveSheet.Name
With ThisWorkbook.Worksheets(x)
n = .Cells(.Rows.Count, 13).End(xlUp).Row
Application.ScreenUpdating = False
For I = 7 To n
.Cells(I, 14).ClearContents
Next I
End With
End Sub
Any idea will be great !
Thank you
Loadlucas