Thread: Typing vs VBA
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
jg jg is offline
external usenet poster
 
Posts: 42
Default Typing vs VBA

I'm not following you here. I don't have any single quotes in my formula.
If you're referring to double quotes, I already have 2 double quotes where a
double quote would appear in the cell.

The root of the issue has something to do with the fact that I can key this
thing in and it works just fine, but not if it's recorded/edited.

"Peter T" wrote:

You need to replace all the quotes with double quotes
Copy your formula into another cell preceded with an apostrophe
do search/replace " (single-quote) with (say) a #

Copy the new formula into the VBE but discard the leading apostrophe

sFmla = "=my new formula with # replacing each single quote"
sFmla = Replace(sFmla, "#", """")

Regards,
Peter T