Deleting Content of a Cell till the End of Right (Not Row)

Dear All,

I need help on Excel 2007 Macro , the below coding searches for a string "recvtiming" in a cell as a wildcard and delete it entire row once it founds it in a single active sheet.

Question,
1. How do I manipulate it to search for the same string and upon finding
a) Delete its cell content and all the contents from its right hand of side till its last column which have a value from the same row on all 50 sheets in the workbook.

e.g
a b c d recv 0 1 2 3 4

It should return,
a b c d

====================Start Code ====================

Please Login or Register  to view this content.

====================End Code ====================

Hello svanan,

Welcome to the Forum!

This macro will look through all the worksheets and find all occurances of "revtiming" and delete the data in that cell and all others to the right in the same row.

Please Login or Register  to view this content.

Try this:

Please Login or Register  to view this content.

Could you advice where it failed earlier.

This is an invalid construct:

Please Login or Register  to view this content.

I will find way to close this thread as solved.

For that and other useful information, see the forum rules.