Thread: Hyperlink function and copy the cells without the function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
arnies arnies is offline
external usenet poster
  
Posts: 1
Default 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


Reply With QuoteReply With Quote