Get Link From Cell

keith0528

Active Member
Joined
Apr 23, 2009
Messages
250
Hi All,

The user will paste a network link into cell A2 of Sheet1. It will not necessarily be the same link everytime. How do i tell VBA to grab the link in cell A2?







thanks in advance
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

wigi

Well-known Member
Joined
Jul 10, 2006
Messages
7,953
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
  3. Web
Hello

For instance,

Code:
Sub test()  
    MsgBox [Sheet1!A2].Hyperlinks(1).Address
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,109,204
Messages
5,527,396
Members
409,759
Latest member
KCH

This Week's Hot Topics

Top