david gabra
Member
Hi
I have the below.
I would like so that the ''2'!A1" will be dynamic and taken from the cell I am standing on
Is that possible?
>>> use code - tags <<<
thanks
I have the below.
I would like so that the ''2'!A1" will be dynamic and taken from the cell I am standing on
Is that possible?
>>> use code - tags <<<
Code:
Sub Macro3()
'
' Macro3 Macro
'
'
Selection.Hyperlinks(1).SubAddress = "'2'!A1"
End Sub
thanks
Last edited by a moderator: