blis
02-15-2010, 02:24 PM
Hi all.
I am trying to insert hyperlink function to active cell (active cell changes during loop in my macro). Hyperlink function should get its arguments from other sheet.
for exampe, =hyperlink(ListOfHypers!A1;ListofHypers!B1), next time it should be inserted =hyperlink(ListOfHypers!A2;ListofHypers!B2) etc
How can translate this to VBA?
thx for help
I am trying to insert hyperlink function to active cell (active cell changes during loop in my macro). Hyperlink function should get its arguments from other sheet.
for exampe, =hyperlink(ListOfHypers!A1;ListofHypers!B1), next time it should be inserted =hyperlink(ListOfHypers!A2;ListofHypers!B2) etc
How can translate this to VBA?
thx for help