Hi guys,
Need some help with VBA with regards to clearing a data set.
I want to clear data down to the last row but keep the formulas I have in the end columns.
Data set to clear would be columns D:BH, rows 5:last populated row.
Currently I have...
Need some help with VBA with regards to clearing a data set.
I want to clear data down to the last row but keep the formulas I have in the end columns.
Data set to clear would be columns D:BH, rows 5:last populated row.
Currently I have...
VBA Code:
Sub Clear_Data()
Application.ScreenUpdating = False
ActiveSheet.Range("D5:BH100000").ClearContents
Next
Application.ScreenUpdating = True
End Sub