创建到另一个工作表的超链接 [英] Create hyperlink to another sheet

问题描述

我的工作簿的第一页就像一个目录页. A列中的每个单元格都包含一个IP地址字符串.对于每个IP地址字符串，都有一个以IP地址命名的工作表.

The first sheet of my workbook is like a contents page. Each cell in column A holds an IP address string. For each IP address string, there is a worksheet named with the IP address.

我想将A列的单元格中的字符串转换为超链接，以指向其相应的工作表(目标工作表的单元格A1).

I want to turn the string in the cells in column A into hyperlinks to their corresponding sheets (cell A1 of the destination sheet).

我只需要用于创建超链接的VBA行；我可以弄清楚循环，等等.请记住，要链接到的工作表的名称与将成为链接的单元格的值相同.

I only need the VBA line that makes the hyperlink; I can figure out the looping, etc. Remember that the name of the sheet to be linked to is the same as the value of the cell that will become the link.

研究仅提出了论坛帖子，这些论坛帖子给出了一堆代码，而没有解释其中的任何内容.

Research has only brought up forum posts that give a stack of code without explaining any of it.

推荐答案

我记录了一个制作hiperlink的宏.结果.

I recorded a macro making a hiperlink. This resulted.

ActiveCell.FormulaR1C1 = "=HYPERLINK(""[Workbook.xlsx]Sheet1!A1"",""CLICK HERE"")"

这篇关于创建到另一个工作表的超链接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！