VBA InStr OR

[hobbiton73]

Hi, I wonder whether someone may be able to help me please

I'm using the line of code below to extract certain pieces information using the 'InStr' function.

Please Login or Register  to view this content.

This part of the code is working fine:

Please Login or Register  to view this content.

But I'm having some difficulty in getting the second part of the line working i.e

Please Login or Register  to view this content.

What I'm trying to say is if .offset(i, 3) = "C&R Principal Practitioner" OR .offset(i, 3) = "C&R Senior Analyst" OR .offset(i, 3) = "C&R Analyst" And PDate = CMonth And AFTE > 0 Then but the results returned are only for the first value.

I just wondered whether someone may be able to look at this please and offer some guidance on how I may go about making the changes so that it is an 'Or' statement and the whole cell has to match these values rather than just 'InStr'.

Many thanks and kind regards

[mrice]

Maybe

Please Login or Register  to view this content.

[hobbiton73]

Hi @mrice, thank you very much for taking the time to reply to my post and for the solution. It's exactly what I was after and works great.

All the best and kind regards