Code to check if cells contain value

[JohnGaltnl]

Dear users,

I'm trying to write a code to check if cells in a specific row contain values. If they contain values the next sub will be played otherwise there will be a messagebox and it will exit the sub.

Below a short version of the code i'm trying to write. in Column C from row 7 each cell has a text. Some cells contain the value 'New'.
Somehow the code below doesnt work and I don't understand why. It should find the value New and if the value is found the messagebox will appear. But if this already wont work then there's no point for me in extending the code.

Can anyone tell me what i'm doing wrong?

Please Login or Register  to view this content.

The code should look something like this

Please Login or Register  to view this content.

[TMS]

Not easy to check without some test data ...

The compare is case sensitive so "New" will not match "new" ... could be one problem.

You also have a variable, "r", which you define and initialise but don't increment ... possibly another problem.

If you're trying to compare cells on the same row as MyCell, you could use:

Please Login or Register  to view this content.

instead of:

Please Login or Register  to view this content.

Regards, TMS

[Richard Buttrey]

Maybe something like

Please Login or Register  to view this content.