im sorry all i explained bad...
i need to copy paste that cell's value ... to here...


and i need just visual basic..not formula...
because i can have need to cancel other workbook but i need the value to
stay..
ty







"dmoney" wrote:

Range("c28").Select
ActiveCell.FormulaR1C1 = _
"='C:\path\[workbookname.xls]Sheet1'!R27C1"


"pls123" wrote:

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