|
本帖最后由 下雨天跑的快 于 2013-1-20 12:05 编辑
Sub AutoGenerateHyperlinks()
Dim nIndex As Integer
Dim oRange As Range
For nIndex = 2 To Sheets.Count
Set oRange = Cells(Selection.Row + nIndex - 2, Selection.Column)
oRange.Hyperlinks.Add Anchor:=oRange, Address:="", SubAddress:=Sheets(nIndex).Name & "!A1", TextToDisplay:=Sheets(nIndex).Name
Next
End Sub
以上实现将一个工作簿中在第一个工作表添加其他工作表的超链接
Sub ab()
Dim nIndex As Integer
Dim bg As Integer
Dim oRange As Range
For nIndex = 2 To Sheets.Count
Set oRange = Cells(Selection.Row + nIndex - 2, Selection.Column)
oRange.Value = Worksheets(nIndex).Range("G1").Value
Next
End Sub
这个想在第一个工作表中引用后面工作中G1单元格的内容
第一个代码(填加超链接的)能用,第二个不能用,运行不报错,没任何输出 求解如何改啊?
- Sub ab()
- Dim nIndex As Integer
- Dim bg As Integer
- Dim oRange As Range
- For nIndex = 2 To Sheets.Count
- Set oRange = Cells(Selection.Row + nIndex - 2, Selection.Column)
- Debug.Print oRange.Address(False, False)
- oRange.Value = Worksheets(nIndex).Range("G1").Value
- Debug.Print Worksheets(nIndex).Name & "!g1=" & worksheets(nIndex).Range("g1")
- Next
- End Sub
复制代码看本地窗口的输出。
|
|