Hi
try
worksheets("sheet2").cells(10,10).value = _
worksheets("sheet1").cells(1,1).value



--
Regards
Frank Kabel
Frankfurt, Germany

"Sylvester" schrieb im
Newsbeitrag ...
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