If - else type mismatch

Hello and thanks in advance for reading.

In my macro, I scan some cells and process some info accordingly. I am trying to input this condition, if the offset of the cell is a certain string, then do something, else do nothing, as seen from below:

Please Login or Register  to view this content.

The problem is, i keep getting a Type Mismatch error. May I know how can I fix this? Thanks a lot!

Hi

Just to expand on what Leith said, you would need to re-write your If statement as:

Please Login or Register  to view this content.

The Select Case End structure makes it much easier to read.

Richard

I'll use the Select Case way then, didnt know i could use it in that manner too. thanks a lot for your help, appreciate it!