What does $ mean?

[Oorang]

I was looking at a snippet of meone elses code, and they used Right$ instead of Right. What is the difference between the two?

 

[Norie]

deleted

 

[Oorang]

True, among other things variants consume much more memory. Thanks Norie, that was driving me crazy

I can't find anything in the helpfile about the use of $. What functions can you use it with? Are there other symbolics you can use to return other datatypes?

 

[NateO]

Hello,

See the following for Strings:

http://www.aivosto.com/vbtips/stringopt.html

And the following for type declarations:

http://j-walk.com/ss/excel/faqs/xl95faq2.htm

Under What's a type definition character? While I personally don't use them...

 

[Oorang]

Hey thanks LOTS of good stuff there.

 

[NateO]

You're welcome.

To clarify, I do use String Functions when I want String returns, but I don't use type-def chars when I declare my Vars.

 

[Oorang]

I AM noticing one thng though. I have people a work that use reports with comments longer then 255 characters . Which pretty much means if I don't put in an error handling routine LenB isn't usable. That seem s to be the problem with a lot of faster things... They're all brittle