I trying to create a hyperlink to a website using CONCATENATE but when i click on the hyperlink it says file cannot be found.
=HYPERLINK(CONCATENATE($J$1,A2))
the link does work if i copy and paste it my self.
I trying to create a hyperlink to a website using CONCATENATE but when i click on the hyperlink it says file cannot be found.
=HYPERLINK(CONCATENATE($J$1,A2))
the link does work if i copy and paste it my self.
if you click on the FX on the formula bar while pointing the mouse to CONCATENATE($J$1,A2), what does it tell you? How does that compare to what you wanted?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Show us what's in J1 and A2.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Image of the Error when i click J2
Help Pic.jpg
When i click on FX
help pic2.jpg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks