vba code for replace

[Eng.Rafed]

Hi

I need code for replace rows if i delete any row from table it will remove all rows to up by Vba . I Attach a file as example .

[YasserKhalil]

Try this code

Please Login or Register  to view this content.

[Eng.Rafed]

thanks for you Yasser .
this code delete row which i chose but i need to delete the data only .

[YasserKhalil]

You can use ClearContents instead of Delete in that case

[ImranBhatti]

Try this after deleting a row. or you may put it into worksheet_Change event

Please Login or Register  to view this content.

[Eng.Rafed]

thanks Yasser & Imran
I did mix yours codes and do some changes to work perfect

Please Login or Register  to view this content.

[ImranBhatti]

You don't need to type thanks .The forum has a button to say thanks to those who help out. just bellow the post of your helper on left hand side corner there is a * button click this to thank. This will save you from typing