View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default link to a cell in another page in vbe..

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!!!