Error when hyperlinking Excel cells to worksheets based on the cell values for sheets whose name in

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Error when hyperlinking Excel cells to worksheets based on the cell values for sheets whose name in

FAQ

Thread Tools

Display Modes

08-01-2023, 02:32 AM

p45cal

Windows 10 Error when hyperlinking Excel cells to worksheets based on the cell values for sheets whose name in

Office 2021

Expert

Join Date: Apr 2014

Posts: 956

Change to:

Code:

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:="'" & Selection.Value & "'!A1"

but you could try this instead:

Code:

Sub FShyeperlink()
Dim cll As Range
'On Error Resume Next' only use this if you need it.
For Each cll In Selection.Cells
  cll.Hyperlinks.Delete
  cll.Parent.Hyperlinks.Add Anchor:=cll, Address:="", SubAddress:="'" & cll.Value & "'!A1"
Next cll
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Merging 2 different cells containing IF formula & change in cell values based on multiple time frame	jay_excel	Excel	0	07-29-2017 11:04 PM
copy cells from a worksheet into other worksheets based on Criteria	Elton Wolter	Excel Programming	4	04-16-2016 08:44 AM
Column B Cell 25 of all worksheets copies data found in the lower cells ...	rpcalo	Excel	3	03-10-2016 03:38 AM
Reference another workbook and return values from the same cell across multiple sheets/tabs	lwls	Excel Programming	5	11-08-2014 02:11 PM
Change values in cells based on criteria	SaneMan	Excel Programming	2	02-02-2012 07:58 AM