Hyperlink function and copy the cells without the function
 

Usimg: 2003 version

In colA the names, and i colB the urls, and in colc the function
=hyperlink(a1;b1)
example: a1=google, b1=http://www.google.com/

The function is copied downi lC: OK
Ptroblem: colC is to be copied elsewhere (each cell including both the text
and Url) but not the function.(references)

What to do?
arnie