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
|