I forgot to say something in my last response to you.

So, all that said, is there a way that I can string a series of
& chr() & together to get all of the characters I need, without having to
enter them manually after the macro has run?

There are times when I'd like to also include some function that I've dim'd
as well.

E.g.,

ActiveCell.FormulaR1C1= "=sumproduct((......" & MyRng & & chr(n) &_
& chr(n_a) & & chr(n_b) & "....................."

Thank you.