Swarnendu
07-21-2017, 12:50 PM
Hi,
So, I have a worksheet where the cells in Column-A (A2:A218) is hyperlinked. And, the values in Column-B (B2:B218) keep changing every 5 minutes.
I need to follow certain hyperlinks and open the webpages whenever the value in the adjacent cell (B2:B218) is <>0.
For example: During a certain time,
If B2=-4, the webpage hyperlinked in A2 opens
If B24=.01, the webpage hyperlinked in A24 opens
If B218=0, the webpage hyperlinked in A218 DOESN'T open
How can I assign a macro to do the job instead of clicking the cells myself?
Thanks,
Swarnendu
So, I have a worksheet where the cells in Column-A (A2:A218) is hyperlinked. And, the values in Column-B (B2:B218) keep changing every 5 minutes.
I need to follow certain hyperlinks and open the webpages whenever the value in the adjacent cell (B2:B218) is <>0.
For example: During a certain time,
If B2=-4, the webpage hyperlinked in A2 opens
If B24=.01, the webpage hyperlinked in A24 opens
If B218=0, the webpage hyperlinked in A218 DOESN'T open
How can I assign a macro to do the job instead of clicking the cells myself?
Thanks,
Swarnendu