First: Don't use Left and Right when you can use mid, to get midle sections of strings.
I'm not sure what your'e doing but type mismatch was caused cuz your AND will return a boolean and don't match chr(9) witch is a string.
Printable View
First: Don't use Left and Right when you can use mid, to get midle sections of strings.
I'm not sure what your'e doing but type mismatch was caused cuz your AND will return a boolean and don't match chr(9) witch is a string.
Also, AND operator compares only numerical values. You're using AND with two strings:)
Hello ArchiGold!
I am not sure what you are trying to do.
Anyway, if you are trying to insert a tab into a string, concatenate the string with "vbTab".
If you are tring to detect a Tab in a string, use "Instr" with "vbTab"
And if you are trying to replace it with something. Use "Replace" with "vbTab" and whatever you want to replace it with.