"Bob Phillips" wrote...
Yeah good, but it does mean that you have to parse the formula to know that
it has no cell reference or not. But I suppose that it needs to be done to
make the routine more robust.
...

Adding two Application.WorksheetFunction.Substitute calls doesn't seem like an
undue burden. Still, it'd nice if Excel generated .Formula1 based on the
referenced cell rather than the calling cell.

--
To top-post is human, to bottom-post and snip is sublime.