VBA to Delete each row based on cell value

[naresh73]

Hi Team,
I tried to search for similar post as this is one of such that most people might have faced, but left no luck
Team please assist and help me to identify where am I missing in the below code
It doesn't work as I want it to, instead delete each and every row.

Trying to delete all rows with text "True" in column "K"

Please Login or Register  to view this content.

Thanks for your time in helping team

[Bernie Deitrick]

VBA text comparisons are case sensitive, so if your entries were "True" and not "TRUE" , or if TRUE is not text but a boolean, then it is not "TRUE" (a lot depends on how it is entered.) So if you want to delete those rows with true, try this, which will delete rows with the text "True", "TRUE", or the boolean TRUE.

Please Login or Register  to view this content.

[naresh73]

I am afraid I dont see the conditional row delete in the above code. Is something missing in here please help.
And it doesnt work and stop at the below line

Please Login or Register  to view this content.

[LeoTaxi]

Maybe time to show your file


Cheers
Leo

[naresh73]

It worked, I removed """ from my code and it worked. thanks team