Need to search for a specific string in Column A and delete values within the same row

Hi all,

I have a spreadsheet with values in Columns A:AP. Most of these values in Column A are 4 digit numbers but once in a while the value will be "Group key". The number of rows in the spreadsheet varies from week to week, as does the placement of the cells that read "Group key". It will always be in Column A but the row number is impossible to predict. Also, there can be multiple instances of the "Group key" cells in the same spreadsheet. What I need is a code that will find ALL instances of "Group key" in column A, and then clear the values in columns D through AP within the row that the cell with "Group key" is found. I know how to write code to delete the entire row, but I need to keep the row and just clear values in the columns I mentioned.

Thanks for any help!

This code will be almost identical.
In the one for whole rows you will have something like

Please Login or Register  to view this content.

in the case described you need something like:

Please Login or Register  to view this content.

instead

Hi Kaper,

Thanks for your input. Here is the code I have that deletes the whole row:

Please Login or Register  to view this content.

How can I modify this to clear Columns D:AP in that row rather than deleting entire row?

For instance:

Please Login or Register  to view this content.

PS1: As you do not delete contents the loop can be either bottom->up (step -1) as it is now or top->down (more natural)

Please Login or Register  to view this content.

PS2: code tags improve readability of post (and are required by forum rules) so my kind suggestion - edit your post.

No way, it:

Please Login or Register  to view this content.

deletes whole rows. No way.

(Ok if there are some event handling procedures or something special, but normally - no way)


The same I can say about starting from column D and resizing 39 (not checked this number) columns. and clearcontents.


A side comment on:

>0
vs
=1

The latter works only if the text is leftmost in the string. The first works also with "Blah blah Group key blah blah ..." in column A