Apologies for the cross post etiquette. Appreciate all the help! I have a solution that now works.

Can't see how to edit first post anymore. Other links:
https://www.excelforum.com/excel-for...ngle-cell.html
https://www.mrexcel.com/forum/excel-...ml#post4863554