Originally Posted by jack_n_bub

Hi,

Is it fine for you to share a sample. As told earlier, there are better ways to perform your task but I provided the solution as per your requirement.

I can look into your code and make necessary corrections and send it back to you.

By the way, you need to run my macro after you have activated the sheet which has column D you are checking for. And I am also assuming that the keyword True is a logical value not a text, i.e. not "TRUE" but TRUE (logical value).

Thanks,
Prashant