Select Case problem

[Darthzo]

Hello

I am working on a problem where I have to search the string in column B and if it contains a value say "C21" I want column C to input "Century 21" Here is the code I have so far below. Its not adding the values to column C for me any thoughs on this?

Please Login or Register  to view this content.

Moderators Note: Please follow forum rules and use code tags. Added for you this time, but please use them in the future…Thanks.

[Leith Ross]

Hello Darthzo,

You are already searching for the strings that match what you are looking for. The Select Case statement is superfluous. The code below will fill in the column "C".

Please Login or Register  to view this content.

[Darthzo]

Could you explain how the .text works in your syntax above please

[Leith Ross]

Hello Darthzo,

The .Text is a Range object Property that returns the .Value as a Text String, regardless of what the value is.

[Darthzo]

Thank you so much Leith!