View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Selection.Replace What and double quotes

When I have problems with double quotes there is always one method that works

What:= chr(34) ' one quote
or
What:= chr(34) & chr(34) 'two quotes
or
What:= chr(34) & chr(34) & chr(34) 'three quotes

"Ed Peters" wrote:

On 13 Sep, 07:26, "Rick Rothstein \(MVP - VB\)"
wrote:
Change your What value to this...

What:=""""

There are 4 quote marks after the equal sign.

Rick

"Ed Peters" wrote in message

oups.com...



Hi all,


I need to replace double quotes " with nothing.


However the code below does not work for double quotes.


Selection.Replace What:=""", Replacement:=""


Any ideas?


Thanks,


Ed- Hide quoted text -


- Show quoted text -


Thanks but that does not work. I can replace any other character but
not "...
Ed