Type mismatch when selecting filtered cell

[ks100]

What am I doing wrong? I am getting a typemismatch on

Please Login or Register  to view this content.

from the script below:

Please Login or Register  to view this content.

This is only the beginning of the script which is why you don't see the end with/loop, etc. but it is stopping on the line I listed above. Any idea why that's giving me a type mismatch?

[stnkynts]

Because the variable is the wrong type. i.e. not a string.

Depending on what is going on it is probably either going to be a range (you will have to "set" the variable and remove the ".Value") or the variable type will be variant (if it is variant you can leave it as is). However, either way you do it you should probably have a firm understanding of what each means or else you will probably run into issues when you try to use the variable