find all instances for specific value in first column

[YasserKhalil]

Hello everyone
I have a code that is supposed to find all the instances of specific string 'Total' in my example
I need to select not only found cells but to select two cells before it too ...
For example :
When applying the code : the following cells are selected (A5 - A12 - A18 - A25)
I need to select also two cells before each cell ..that's to select also A4 and A3 ...A11 and A10 .. A17 and A16 ... A24 and A23

So the required result is to select all the following cells (store them in Rng Variable) :::A3 - A4 - A5 - A10 - A11 - A12 - A16 - A17 - A18 - A23 - A24 -A25
Hope it is clear

[TMS]

Try:

Please Login or Register  to view this content.

Regards, TMS

[YasserKhalil]

Thanks a lot Mr. TMS
It is working like charm

I tried before your post to do the same but with this line

Please Login or Register  to view this content.

But of course I got an error

Thank you very much for great and quick help

[TMS]

You're welcome. Thanks for the rep.