VBA to Clear Contents of Filtered Range

I have a file with data from data in column A thru column BQ with column A having data in each row and the number of rows vary. There are headers in the first row.

Below is the macro I wrote but doesn't work as planned. It is suppose to filter column AC for "Constant". If any "Constant" appears, clear only the data in column AC that has "Constant". If no "Constant" appears, do nothing.

I appreciate any help.

Please Login or Register  to view this content.

You're filtering for "Continuous" instead of "Constant" in the AutoFilter line — looks like a simple slip.

You're using LastRow before assigning it a value, which might cause an error.

You’re checking the number of visible cells but referencing LastRow again in that range, which could misalign if the filtered range is smaller.

Here’s a refined version that directly checks for "Constant" in column AC and clears those visible cells if any are found:

Please Login or Register  to view this content.

All of these worked. Thanks so much.

Sintek - I think when I added reputation, I clicked disapprove instead of approve in error but left very positive comments. I contacted the admin to see if someone could check if I clicked the wrong button and correct it if I did. My apologies if I did so. Your code worked perfectly. Your second option was in fact the one I went with! Thanks again for your help.

Originally Posted by ellenlewis

I think when I added reputation,

By the way, I'm asking. What's with this reputation, that everyone is hunting for reputation? For me, since you wrote post #5, "Thank you" is enough. I won't get bread or wine for reputation. To give reputation without post #5 means, I understand, that one shouldn't litter the forum.
Why both "Thank you" and reputation?

Thank you. Best wishes in your endeavors.

Honestly, I'm not sure. But whenever someone helps me and their code works, I always add reputation because I certainly appreciate your time and expertise. Perhaps with enough reputations, the bread and wine will come! If that is the case, I will continue to do my part in hopes of getting you some bread and wine!

Thanks so much for your help!