Simplify code

Hey

Is it possible to simplify this code:

Please Login or Register  to view this content.

I want to make an efficient (fast) code, but this looks terrible. ....any suggestions?

Hi KBSH,

Instead of

Please Login or Register  to view this content.

try

Please Login or Register  to view this content.

See if that makes more sense and works better for you.

I don't know the code InStr(), but found out that it worked, so thanks. I did actually hope that it would be more something like Activecell.value = OTA

The thing that I actually ment is that I have to declare twice that I'm looking for characters like "A" "T" and "O"

Please Login or Register  to view this content.

Can't this be done with just one line?

I tried using Instr but for some reason I was getting errors so I decided to use match.

Please Login or Register  to view this content.

Thanks mehmetcik. I didn't know that you can work with numbers in front of your code and refer to those numbers. Very useful