Excel 如何用hyperlink函数实现跳转到B列最后一个非空白单元格所在的位置，公式要怎样写呢？急！
Excel 如何用hyperlink函数实现跳转到B列最后一个非空白单元格所在的位置，公式要怎样写呢？急！！！请高手们帮忙解决！
试下这个：
=HYPERLINK("#B"&LARGE(IF($B$2:$B$23<>"",ROW($B$2:$B$23),0),1),"B列最后非空") 同时按下Ctrl+Shift+Enter三键输入数组公式
温馨提示：答案为网友推荐，仅供参考
第1个回答 推荐于2016-05-09
公式：
=HYPERLINK("#b"&COUNTA(INDIRECT("B"&ROW()+1&":B10000"))+ROW(),)
第2个回答 2015-07-28
=HYPERLINK("#B"&COUNTA(B:B),"最后一个单元格")
第3个回答 2015-07-28
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim addr1 As String, addr2 As String, rng1 As Range, rng2 As Range
addr1 = "a1" '要插入超级链接的地址
Set rng1 = Sh.Range(addr1)
addr2 = Sh.range("B65536").end(xlup).address 'B 列最后单元格地址
Set rng2 = Sh.Range(addr2)
'Sh.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
'"Sheet1!A1", TextToDisplay:="Sheet1!A1"
Sh.Hyperlinks.Add Anchor:=rng1, Address:="", SubAddress:= _
rng2.Address, TextToDisplay:=rng2.Address
End Sub
上面这个放在 thisworkbook里面，对所有表格生效本回答被网友采纳
Dim addr1 As String, addr2 As String, rng1 As Range, rng2 As Range
addr1 = "a1" '要插入超级链接的地址
Set rng1 = Sh.Range(addr1)
addr2 = Sh.range("B65536").end(xlup).address 'B 列最后单元格地址
Set rng2 = Sh.Range(addr2)
'Sh.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
'"Sheet1!A1", TextToDisplay:="Sheet1!A1"
Sh.Hyperlinks.Add Anchor:=rng1, Address:="", SubAddress:= _
rng2.Address, TextToDisplay:=rng2.Address
End Sub
上面这个放在 thisworkbook里面，对所有表格生效本回答被网友采纳
相似回答