This Hyperlink formula doesnt work
 

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?

This Hyperlink formula doesnt work
 

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?

This Hyperlink formula doesnt work
 

Did you try removing the equal sign from =E5064

--
Regards,
Tom Ogilvy


"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?

This Hyperlink formula doesnt work
 

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?

This Hyperlink formula doesnt work
 

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?

This Hyperlink formula doesnt work
 

GOT IT!!!

Into a command button, works perfect, THANKS A LOT!!! (How many nights
thinking how to do it!)

I´ll copy it here for any ther user:


Private Sub CommandButton6_Click()

Dim sht As String


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

cbm ha escrito:

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?

This Hyperlink formula doesnt work
 

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

worked fine for me. (assuming your list separator is a semicolon - I tested
with a comma since that is the list separator for my regional version of
excel).

--
Regards,
Tom Ogilvy




"cbm" wrote in message
oups.com...
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?