Well, those are the only things I can think of, and I can't verify them - you'll have to do that. What you could do is enter a working formula manually, then with that cell selected, enter:
in the Immediate Window in the VBEditor and compare that to the string being produced by your code.![]()
?activecell.formular1c1
Bookmarks