InStr Function: Can it evaluate strings in a cell?

The code below returns the value of 9.

Please Login or Register  to view this content.

Now let's assume that "XXX-EUR Recharge 999" resides in cell C4. Is there a way to write the code so that InStr evaluates the string in this cell?

I've tried:

recharge_start = InStr(C4, "Recharge")
recharge_start = InStr("C4", "Recharge")
recharge_start = InStr("C" & count, "Recharge")
recharge_start = InStr(Range("C4").Value, "Recharge")

None of these work. If the InStr function cannot do this, is there another function that can do the trick?

The attached file is irrelevant. It related to a more complex question and unfortunately I don't know how to delete it from this post. Please disregard it.

Welcome to the forum.

We'd like to help you but first..

Pls take some minutes to read forum rules and specially-in this case- rule#3