Hello,
I created a Macro to do some simple formatting and formulas which all works great, BUT the more complicated part is that Macro also takes a Hyperlink formula into Word and pastes it, then back into the Excel Workbook so it is no longer a formula and now instead a hyperlink connected to the name. When I read through it everything looks good and there shouldn't be any issues. I would way 10% of the time it comes back with Ref instead of the name meaning somehow the pasted content never made it back into Excel.
I feel like I am missing something here and don't know what it is.
Could someone PLEASE help me I would greatly appreciate it!
VBA Code Attached. (Please let me know if you need anything else from me)
All the best,
Quinn3110