hi pls123
the link to a cell in another page..
Another workbook I think ???
Maybe this give you a few ideas
http://www.rondebruin.nl/summary2.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"pls123" wrote in message ...
hi all !!
i need that !!
how do i write in vb editor
the link to a cell in another page..
like this:
aWS.Range("C28") = C:\sourcepage\sheet1\cell_A27
i also need no edit link prompt in case that page doesn't exist...
ty!!!