Delete range if met a string condition

Hi,

I have this beautiful code, founded on the net.

I want to modify this code to not delete the entire row, but only the a range of row, for example range A1:C20.
Where should I look if I wanted to change this code, or is there is any other solution, somewhere...? May be simpler?

Please find attached an example... with the macro

Please Login or Register  to view this content.

Change code as below:-

Please Login or Register  to view this content.

thanks MickG,

We are getting closer... may be I was not clear to what I want it.
Your solution works great, however I want also that the macro delete in that row a range for example A1:C20.

With your solution, it only deletes that cell value. So what I want is that the delete shift up function should be applied for that row within the range of A to C --> because I have other data in Column D, E and F that not want to be moved or deleted...

I hope I am clear

Whoops... I was too slow writing my reply to MickG.
Kaper, gave me the solution I was looking for!!!

Thanks everyone and wish everyone a great WEEKEND!!!