Hyperlink formula help

D

ddub25

Well-known Member
Joined
Jan 11, 2007
Messages
625
Office Version
  1. 2019
Platform
  1. Windows
Is there a Hyperlink formula I can create that hyperlinks to TEXT located in Column D in the lowest row in a table? Thanks.

Dan
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Sort by date Sort by votes
Maybe... Click on Cell B1
Excel Workbook
AB
1http://www.ford.comLast Row Choice
2http://www.cnn.com
3http://www.msnbc.com
4http://www.ford.com
Sheet1
Excel 2007
Cell Formulas
RangeFormula
B1=HYPERLINK(INDIRECT(ADDRESS(COUNTA(A:A),1)),"Last Row Choice")
 
Upvote 0
I can't get this to work properly. I put the formula in B1 and the text "Last Row Choice" is displayed fine, but when I click on the link it says, "Cannot open the specified file".

Dan
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
Clickable on Filter Formula
Replies
5
Views
182
Peter_SSs
Peter_SSs
S
  • Question Question
HYPERLINK() function Seems Unable to Jump to Another Sheets Table and Filter
Replies
6
Views
339
Skyybot
Skyybot
G
  • Question Question
Hyperlink Help
Replies
1
Views
305
myall_blues
myall_blues
I
  • Question Question
Vba has stopped adding hyperlink to my customers name
Replies
3
Views
101
ipbr21054
I
R
  • Question Question
Excel Launch Hyperlink VBA
Replies
2
Views
137
Robertson1995
R

Forum statistics

Threads
1,224,504
Messages
6,179,142
Members
452,892
Latest member
JUSTOUTOFMYREACH

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top