Is there a test (in VBA) specifically whether a cell has an apostrophe in
the formula ...i.e., that it has been hardcoded by the user as text?
Similarly, is there a way through VBA to insert the same hard-coded text
into a cell.

Thanks.