Oh okay thank you. I didn't realize that - it will make my code easier to read hopefully!

I've been running the macro without any hitches for the past few days, but I noticed when i pull in a number to word, it is ignoring the formatting from excel. If i pull in a dollar amount, number separated with commas, or even a cell that has been conditionally formatted (i have one that turns 150,000 to 150k) it ignores them. It IS working as far as equations go, pulling the value and not the actual formula in the cell.

If either of y'all have any pointers on how to fix that I'd really appreciate it.