View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pls123 pls123 is offline
external usenet poster
 
Posts: 121
Default vbe - copy a cell's value by other workbook

hi all i ask again this question.. i had no answers last time and its very
important for me

i have to copy a cell's value by other workbook..
like this formula :
"='C:\WB\[Sample.Page.xlsm]Sheet1'!$T$13"
but i dont need in formula but in vbe ..
not this ...
Range("A4") = "='C:\WB\[Sample.Page.xlsm]Sheet1'!$T$13"
but a VBE direct input...

its very important because i have a manual calculation called by the macro..
so i have to make that way to have full syncronization of some values...

HELP ME please !!! call some big boss if you can !! ;)