select last row containing specific text in column

[hopefulhart]

hello, i am trying to figure out a vba code to select the last cell in column C that contains "Cgy".

thanks

[sktneer]

You may try this code to see if this works as per your requirement.

Please Login or Register  to view this content.

[hopefulhart]

thanks, that seems to work!!

[sktneer]

Glad that I could help.
You may click on * (star) to Add Reputation, if you think that the solution provided helped you.