[RESOLVED] [Excel VBA] Right$ and Left$

I know what Right and Left do. What is the difference if they have a dollar sign at the end?

Thanks

They do the same thing, but the $ versions use (and return) the String data type rather than the Variant data type.

As such the $ versions tend to be faster, which can be significant if you are using them a lot inside a loop.