Hyperlink formulas (FedEx and UPS) - one works and the other does not

Hello,

I've got two hyperlink formulas in a testing module, and one FedEx) is working, while the other (UPS) is not. I've taken the UPS formula apart and concluded it has something to do with the hyperlink 'friendly name', which I absolutely need. It must be that I've got a quotation mark out of place or something of the sort. It's driving me nuts! See below for the working FedEX and a few of my UPS attempts. Any thoughts? Thank you!

FedEx hyperlink code with TrackingNum variable, works great!
"=HYPERLINK(""https://www.fedex.com/fedextrack/?trknbr=" & TrackingNum & "&trkqual=12021~" & TrackingNum & "~FDEG""," & TrackingNum & ")"

UPS hyperlink code with TrackingNum variable, does not work
"=HYPERLINK(""https://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&loc=en_US&Requester=UPSHome&tracknum=" & TrackingNum & "&AgreeToTermsAndConditions=yes&track.x=17&track.y=4/trackdetails""," & TrackingNum & ")"

Straight up with actual UPS Tracking #. Works.
"=HYPERLINK(""https://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&loc=en_US&Requester=UPSHome&tracknum=1Z9R44231210320802&AgreeToTermsAndConditions=yes&track.x=17&track.y=4/trackdetails"",""1Z9R44231210320802"")"

Attempt with hyperlink and concatenate. Does not work.
"=HYPERLINK(CONCATENATE(""http://wwwapps.ups.com/etracking/tracking.cgi?TypeOfInquiryNumber=T&InquiryNumber1="", & )"

Below is the testing module I've put together to get the FedEx and UPS links working. As I mentioned, the FedEx part works just fine, but the UPS part of the
If statement is throwing a run-time error '1004' Application-defined or object-defined error. The formulas seem to be formatted identically, but I'm obviously
doing something wrong. I'm hoping someone can see something that I've overlooked.

Please Login or Register  to view this content.

Coming back here to post the solution. My son and I came up with a solution, but Rollis13 at VBA Express came up with the more direct and elegant solution. Honestly was just trying to provide the details to different viewers. In the future, I will post the question on one site and the link on the other sites.

http://www.vbaexpress.com/forum/show...550#post408550

How do I mark the post as SOLVED?