Hi Tom, I did but message coudn´t find the reference comes on popping

cbm ha escrito:

Thanks Mike, I´ve put it into a command button bur i had a sintaxis
error:

I guess the error is here, but i don´t knowhow to solve it
SubAddress:= _
sht & "!E7"


Mike Fogleman ha escrito:

This should get you started..

Sub AddHyper()
Dim sht As String

sht = ActiveSheet.Range("E5064").Value
ActiveSheet.Hyperlinks.Add Anchor:=Range("E5064"), Address:="",
SubAddress:= _
sht & "!E7"
End Sub

Mike F
"cbm" wrote in message
oups.com...
Hi, i need a formula to make an Hyperlink to de name of the sheet i
write in cell E5064

I was trying with this but didn´t work

=HYPERLINK("[MACRO EXCEL GENERAR HOJAS Y ESTAD DEFINITIVA.xls]
&(=E5064) &!$E$7"; "Go to this sheet")

Can anybody help PLEASE?