|re: I did not use tables and lists because at the time I wrote this code, I did not know how to use them.|
Perhaps now would be a good time to "fix" the spreadsheet so you don't have to deal with this hard coding issue again.
re: how would I print out the formulas/functions...
Did you try to print the sheets while in Formula View? You might be surprised by what happens.
re: "...so I can check to make sure all of the substitutions were made."
Why not just search for the words that you replaced? If they aren't found, then all of the substitutions were made.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.