Thread: Quote constant?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charlotte E.[_3_] Charlotte E.[_3_] is offline
external usenet poster
 
Posts: 160
Default Quote constant?

Hi,


I would like to make a vbQuote constant, like:

Const vbQuote As String = Chr(34)

....so that I can use vbQuote when I need to insert a " in a string,
instead of Chr(34).

But when I do the above code line to define the constant, I get an error
saying that a constant expression is needed.

But, in my eyes that is a constant expression???

So, how do I make a vbQuote constants?


Thanks,

CE