Delete Data in Cells

[Crazy1923]

Hi everyone,

Do anyone knows how to delete data in a range of cells using VBA. For example, I want to delete data of A1:A5 in just one click.

Thanks

 

[VoG]

Try like this

Sub dlte()
Range("A1:A5").ClearContents
End Sub

 

[Crazy1923]

Thanks a lot. it works