Excel follow Hyperlink not working

B

brobert95

New Member
Joined
Jul 8, 2019
Messages
18
I have the following code that I need to follow a hyperlink. The problem is G7 is using a formula to get the hyperlink from Vlookup. If I manually type the hyperlink into G7, the below code works, but with the formula in G7 it will not. Thanks in advance for any help.

Sub FollowHyperlink()
ActiveSheet.Range("g7").Hyperlinks(1).Follow
End Sub
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
You must log in or register to reply here.

Similar threads

C
  • Solved
Out of Memory Error 7 on text replace
Replies
6
Views
96
Candyman8019
C
Z
  • Question
VBA column print hyperlinks
2
Replies
10
Views
216
Micron
M
P
  • Question
Vlookup with hyperlink not working when source file is closed
Replies
1
Views
139
Deek6t8
D
I
  • Question
Problem with hyperlink and vlookup error "Cannot open the specified file".
Replies
0
Views
142
IggyMBSP115599
I
A
  • Solved
Sending hyperlink filepath via email
Replies
8
Views
361
AndyEd
A

Forum statistics

Threads
1,215,036
Messages
6,122,794
Members
449,095
Latest member
m_smith_solihull

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