If condition is met, clear the cell next to it.

[taylorsm]

I want to add to this that it clears the cell to its right. That is it. No deleting or clearing entire row. The range changes. Can I just do some kind of "offset"? All i find online is trying to clear an entire row or is when the range is set.

Please Login or Register  to view this content.

[Winon]

Hello taylorsm,

Your snippet Code is too incomplete to guess how you want us to magically solve your issue, for me, at least.

Please attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.

[jolivanes]

Try

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

or
many more possiblities

Please Login or Register  to view this content.

[taylorsm]

Jolivanes, thank you. I think your last one is the closet. I can't try right now but will shortly. I don't think you can say to clear any specific range because that will change. It is dependent on the location of the searched word.

Winon, attached is a sample sheet.

[jolivanes]

If, like in the attached example, test3 is always in Column A, the first example would be the way to go.
If there also would be only one time "test3" in that column, you should have an "Exit Sub" in there so it quits going through all the cells after it found the only one.
If test3 could be anywhere, the UsedRange suggestion would work

For only one time "test3"

Please Login or Register  to view this content.

[taylorsm]

No. Won't always be in the same column. This is the full macro I use.

Please Login or Register  to view this content.

[jolivanes]

Try this on a copy of your workbook after extending the arrays.

Please Login or Register  to view this content.

[vcoolio]

Hello Taylorsm,

You could place all the names in a drop down, select the name whose offset(0,1) value you wish to clear then execute the code to clear that value.

Would this method work for you? I've attached an example for you to have a look at. Click on "GO" to execute the code.

The code would be something as follows:-

Please Login or Register  to view this content.

Cheerio,
vcoolio.

[jolivanes]

If it is indeed just a single name in all these ranges, this could be another approach.
vcoolio's approach might be better as it might help with spelling mistakes.

Please Login or Register  to view this content.

I assume, more then likely wrongly so, that there is a reason to have these blocks of ranges.
If not, the UsedRange method could be the way to go.

[vcoolio]

@ Jolivanes:

I assume, more then likely wrongly so, that there is a reason to have these blocks of ranges.

I was wondering about the "blocks" also.

However, the OP now has a few options to play with.

Cheerio,
vcoolio.