添加行或列后Excel更新超链接引用

以下示例是关于Excel中包含添加行或列后Excel更新超链接引用用法的示例代码,想了解添加行或列后Excel更新超链接引用的具体用法?添加行或列后Excel更新超链接引用怎么用?添加行或列后Excel更新超链接引用使用的例子?那么可以参考以下相关示例代码来学习它的具体使用方法。

[英]:excel update hyperlink reference after adding rows or columns源码类型:Excel
# Basic syntax:
=HYPERLINK(CELL("address", INDEX(B:B, MATCH(A1, B:B, 0))), "Link_name")
# Where this will create a link called "Link_name" to the first cell in column
#	B that matches the text in cell A1.
# Note, this approach avoids the issue of having all hyperlink references
#	"broken" when you add a row or column because CELL returns the correct
#	cell address to the HYPERLINK function
# Note, unlike the source I link to, I needed to remove the "#"& in front of
#	the CELL function to get this to work.

本文地址:https://www.itbaoku.cn/snippets/787530.html