LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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 !! ;)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a cell's value to copy another cells info to another workshe badger2407 Excel Worksheet Functions 1 March 16th 10 09:21 PM
Formula to copy another cell's contents - Help! Richorton Excel Discussion (Misc queries) 6 August 7th 08 04:16 PM
A cell's value renders a workbook read-only [email protected] Excel Discussion (Misc queries) 3 December 27th 06 08:53 PM
cell's reference value dependent on another cell's value Flash in the Pan Excel Programming 4 April 6th 06 09:23 PM
How do you copy a cell's content verses it's formula? Tammy Excel Discussion (Misc queries) 1 March 2nd 05 06:30 PM


All times are GMT +1. The time now is 05:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"