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
|