To further Tom's answer check out this link.

http://www.dailydoseofexcel.com/arch...on-efficiency/

It deals with a number of string functions such as Trim, Left, ... and
explains the benefits of using Trim$ and Left$...
--
HTH...

Jim Thomlinson


"Tom Ogilvy" wrote:

that is a form of implicit typing

? typename(msg)
Empty '<== means it is an uninitialized variant
? typename(msg1$)
String

so
Dim msg ' declares it as variant
Dim msg$ ' declares it as String
Dim msg& ' declares it as Long
Dim msg! 'declares it as Single
Dim msg# 'declares it as double
Dim msg% 'declares it as Integer

--
Regards,
Tom Ogilvy


"Steph" wrote:

Hi. I'm getting familiar with code that someone else wrote, and ran across
something I have never seen before. What is the difference between:
Dim Msg
Dim Msg$
What does the $ do? Thanks!