PDA

View Full Version : Insert hyperlink function to active cell



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

lucas
02-15-2010, 03:39 PM
active cell changes during loop in my macro

doesn't that cause a lot of screen flicker and jumping around?

blis
02-15-2010, 04:01 PM
true. but i have 20 workbooks that have 30+ worksheets and i need to covert all inserted hypelinks to functions.... whats worst? looking to sceen flicking for a few seconds or correcting every hypelink by hand :)

If someone will help me with this i can also benefit from using find and replace tool and problem with hyperlinks because of inserting new sheet and rows or columns would be gone.

so pls help me with that. i would really apreciate help with this one. I am new to vba and this is to hard for me at the time.