I am using one line of code to clear the contents of every row in sheet except row 1. I still want to clear all the contents of the sheet with the exception of follow cells:
Row 1 - do not clear contents
Column A - do not clear contents
Column B - do not clear contents
Is there a way to modify code to leave the contents of columns A and B intact?
Thanks
![]()
With wsTradeTable .Range(.Cells(2, 1), .Cells(.Rows.Count, .Columns.Count)).ClearContents End With
Bookmarks