View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dan T[_3_] Dan T[_3_] is offline
external usenet poster
 
Posts: 7
Default Not recognizing a Const

I'm writing a routine to write to a test file. I've had two suggestions;
delimiter=Char(9). This gives me an invalid function all. And;
Const DELIMITER As String = CHR(9), this gives me an error of "Const expression required"
It does not seem to be accepting the chr(9) or the char(9) as a valid literal to set the delimiter to.
Any ideas why?