Using Select Case on a range of cells?

Hello everyone,

I'm stumbled on a bit of a problem, I'm testing a row/range on sheet to determine if one of the cells contains a string I'm looking for.

The code is as follows:

Please Login or Register  to view this content.

Apologies for the messy Range statement, the number of populated columns on each row is dynamic.
When running the code it just skips past the row that contains a cell with the appropriate string.

Is this approach possible with tweaking? Or will I have to code to manually test each cell in sequence?

Thanks for your time.

Adam

Not sure if this will work for you or not.

Please Login or Register  to view this content.