BMD4
07-11-2018, 02:18 PM
Hi,
I am trying to clear contents for column A to D.
I used below statement which worked.
Sheet1.Range("A:D").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
I am trying to clear contents for column A to D.
I used below statement which worked.
Sheet1.Range("A:D").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