hey guys
having problems creating hyperlinks using a macro
i want to be able to highlight a selection and run the macro.
the hyperlink should appear in column E on the same row as the seclection,
and should lead to the selection.
i have tryed this as it looks simple but i always get a Type Missmatch error
tryed this
sSD = E14 in this case
having problems creating hyperlinks using a macro
i want to be able to highlight a selection and run the macro.
the hyperlink should appear in column E on the same row as the seclection,
and should lead to the selection.
i have tryed this as it looks simple but i always get a Type Missmatch error
tryed this
Code:
ActiveSheet.Hyperlinks.Add Anchor:=sSD, Address:=Selection.Address(False, False)