Microsoft, Excel, 2003, VBA Finding text from any part of an active cell?

My Current code below shows the code i currently have.

the variable "D" is just what i have inserted while i dont know what to put, I really want it to say that the activecell.formula contains the word "USER" - this could be at the beginning middle or end of the cell so I can not use LEFT, MIDDLE or RIGHT.

I know in an access query etc I can use a wildcar but this does not seem to work within visual basic (i have picked up what I know from self teaching)

Any help on how i can do this will be appreciated.

Thanks
CraigStart Free Trial

1:

If WS_Sheet1.Range("B" & Sheet_Active_Row).Formula = d Then