Chr and Chr$

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

What is the difference between the Chr and Chr$ and all other similar pairs?

Clara
 
chr or mid or left or... are functions that take variants as arguments.
Variants are inefficient as the function first needs to determine what kind
of varaible it is. By using the dollar sign you are telling the function that
you are passing in a string. This makes the functions more efficient. The
down side is that if you pass in somthing other than a string the function
will bomb...
 
I was unaware of the difference so I read further. I think you got it mixed
up. The args are not variants; the returned values are Variant (no $) or
String ($)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chr$ 3
formattig word paragraphs from excel 5
VB Send Mail using Thunderbird 6
chr$ 12
Split data in field on character return 0
combobox, and chr(10) 7
multiple CHR() in VBA 19
SQL VBA Excel 0

Back
Top