syntax error in an "and" in "if" statement in a "for" loop

Hi,

I am writing a macro that splits numbers and parts of strings from a large string in column A. I want to use an "and" in "if" statement in a "for" loop, but i don't get the syntax right (last line of code below). What is the right syntax?

Any help is much appreciated!

Please Login or Register  to view this content.

I solved it myself. The last line should be:

Please Login or Register  to view this content.