Thread: Chr and Chr$
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Chr and Chr$

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...
--
HTH...

Jim Thomlinson


"clara" wrote:

Hi all,

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

Clara
--
thank you so much for your help