Hi Loïc

Look in the help for the Hyperlink function
You can build the link_location with cell references


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Loïc" wrote in message ...
How can I automatically paste hyperlinks from one cell to another ?

Ex: I have the names of movies in column A and the URL in column B. I want
simply
that excel generate /

<A HREF="URL1"<Bmovie1<BR</B</A
<A HREF="URL2"<Bmovie2<BR</B</A
......

tHANKS FOR YOUR HELP