Hello,
I found problem with my HYPERLINK and really couldn't find solution for that.
I have workbook with few Sheets, one of them is my source data which includes hyperlinks with friendly names and without.
I have problem when i try use one of data with hyperlink covered by friendly name.
I extract the link from hyperlink with function:
and my function looks like this:
=HYPERLINK(GetUrl(INDEX(OnlySource,ROW()-1,MATCH(L$2,Lnk,0))),INDEX(OnlySource,ROW()-1,MATCH(L$2,Lnk,0)))
and this doesn't work.
When i change friendly name part:
to :
"SOME TEXT"
it works.
When i use only:
it works, but i need friendly name for it
which i can get from:
OnlySource is dynamically changing range depends whats data is imported
Lnk is dynamically changing range for headers depends whats data is imported
Please help with some solution to be able have working hyperlink with valid friendly name which is taken from same cell.
I found problem with my HYPERLINK and really couldn't find solution for that.
I have workbook with few Sheets, one of them is my source data which includes hyperlinks with friendly names and without.
I have problem when i try use one of data with hyperlink covered by friendly name.
I extract the link from hyperlink with function:
VBA Code:
Function GetUrl(WorkingRng As Range) As String
GetUrl = WorkingRng.Hyperlinks(1).Address
End Function
and my function looks like this:
=HYPERLINK(GetUrl(INDEX(OnlySource,ROW()-1,MATCH(L$2,Lnk,0))),INDEX(OnlySource,ROW()-1,MATCH(L$2,Lnk,0)))
and this doesn't work.
When i change friendly name part:
Rich (BB code):
INDEX(OnlySource,ROW()-1,MATCH(L$2,Lnk,0))
to :
"SOME TEXT"
it works.
When i use only:
Rich (BB code):
=HYPERLINK(GetUrl(INDEX(OnlySource,ROW()-1,MATCH(L$2,Lnk,0))))
it works, but i need friendly name for it
which i can get from:
Rich (BB code):
INDEX(OnlySource,ROW()-1,MATCH(L$2,Lnk,0))
OnlySource is dynamically changing range depends whats data is imported
Rich (BB code):
=OFFSET('1st PASTE AIMS SOURCE'!$A$2,0,0,COUNTA('1st PASTE AIMS SOURCE'!$A:$A),COUNTA('1st PASTE AIMS SOURCE'!$2:$2)-1)
Rich (BB code):
=OFFSET('1st PASTE AIMS SOURCE'!$A$2,0,0,1,COUNTA('1st PASTE AIMS SOURCE'!$2:$2)-1)
Please help with some solution to be able have working hyperlink with valid friendly name which is taken from same cell.