Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why doesnt this work? | Excel Worksheet Functions | |||
Formula doesnt work when copy in different cell | Excel Discussion (Misc queries) | |||
doesnt become Hyperlink | Excel Programming | |||
Formula doesnt work | Excel Worksheet Functions | |||
excel lookup help... already have formula but doesnt always work | Excel Programming |