View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sylvester[_2_] Sylvester[_2_] is offline
external usenet poster
 
Posts: 2
Default How handle Hyperlinks

I have amacro that goes through sheet1, reads what it has
to and writes to sheet2. The data is processed as string
variables using Cell references.

There are some hyperlinks that I would like to put to
sheet2 also but I can't make a go of it.

Say Sheet1 Cells(1,1)is a hyperlink .. How do I put it in
Sheet2 Cells(10,10)??

Many thanks,

Sly