Hyperlink anchored to a column

[Tortus]

Is there a way to automatically use each cell value in a column to finish a hyperlink address?

Good example would be lets say "DOG" was in A10. When the user clicks A10 it would direct to https://www.google.com/search?q=DOG

[mjr veverka]

Try:

Please Login or Register  to view this content.

[Tortus]

Thanks Porucha - for some reason I'm getting a debug at

Please Login or Register  to view this content.

[Tortus]

Can anyone help me on this please? I've tried a couple of different things using the code provided with no luck.