Info: use vbNullString

[dis1411]

attention everyone: you should never ever be using "" to mean an empty string. use the constant vbNullString.

"" makes the computer generate a null string
vbNullString simply is a null string

break the "" habit

but, before you change all your If statements, consider this:

If StrTemp = vbNullString Then

is slower than

If LenB(StrTemp) = 0 Then

so code accordingly

that is all