Writting a Hyperlink Formula with Macros

[Andlopezgo]

Hello there, I have a simple Hyperlink formula:

=HYPERLINK("#Index!A7","Link")

How can I make the sheet name and the cell dynamic?.

Something like:

Sheets("Summary").Cells(lastrow + 1, 8).Value = "=HYPERLINK(""#ActiveWorkbook.Worksheets(i).Name ! ActiveWorkbook.Worksheets(I).Cells(j, 1).Value"",""Link"")"

Thanks in advance for the help.

BR

AL

 

[FormR]

You need to concatenate in the dynamic parts - something like this maybe.

Sheets("Summary").Cells(lastrow + 1, 8).Value = "=HYPERLINK(""#'" & ActiveWorkbook.Worksheets(I).Name & "'!" & ActiveWorkbook.Worksheets(I).Cells(J, 1).Address & """,""Link"")"

 

[Andlopezgo]

You need to concatenate in the dynamic parts - something like this maybe.

Sheets("Summary").Cells(lastrow + 1, 8).Value = "=HYPERLINK(""#'" & ActiveWorkbook.Worksheets(I).Name & "'!" & ActiveWorkbook.Worksheets(I).Cells(J, 1).Address & """,""Link"")"

Hey FormR, Thank you so much for your help. It is working just fine.

Have a great of the day.