Code:
Ws3.Range("B" & cnt & ":" & CL(Lc) & cnt & "").ClearContents
I putted this code i am not getting any error but it is not clearing the data
i tried this also
Code:
Ws3.Range("B" & cnt & ":" & CL(Lc) & cnt & "").cells.ClearContents
but this is also not clearing the data Doc Sir plz relook sir