Hi,
I am trying to clear contents for column A to D.
I used below statement which worked.


Sheet1.Range("A").ClearContents

Now, I have a scenario where in I should not delete value in cell A1.
My range is from A2 till Col A end and Cols B,C and D.
Can anyone suggest how can we get this range cleared
Thanks in advance