Thread: VBA Find and Replace isn't working on apostrophe within cell value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon[_18_] Jon[_18_] is offline
external usenet poster
  
Posts: 5
Default VBA Find and Replace isn't working on apostrophe within cell value
I gave up on using the Excel native find and replace. I think it's an
Excell 2007 bug.

I'm now passing the value of the cell into a string and replacing the
apostrophe there.

Call EscapeApostrophe(Activecell.Value)

Function EscapeApostrophe(strComment)

Reply With QuoteReply With Quote