need VBA code

[AhmedRady]

Hello All,
as i try to learn my self how to use VBA

kindly i need a vba code to delete ACTIVE cell contents , as when i select a cell i can delete all the contents in the same row

 

[Joe4]

Try this:

Rows(ActiveCell.Row).ClearContents

 

[AhmedRady]

thank you , it's working

 

[Joe4]

You are welcome.

 

[Rick Rothstein]

Try this:

Rows(ActiveCell.Row).ClearContents

Just for future readers of this thread, another way to write this code line...

ActiveCell.EntireRow.ClearContents