I don't see how this would help. VBA tries to be strongly typed but then finds it needs to have weak typing available. The variant is its weakly typed scalar, so, unless I have something wrong, your suggestion would involve coercing a string into a variant in a situation where it is known to be a string & can be strongly typed. While putting it in a variable shortens the code, which can be desirable, the advantage of a variant isn't immediately obvious to me.

Regards,

John Davies