PDA

View Full Version : Solved: codename donot work



fanjy
10-28-2007, 01:46 AM
hi,everyone.
I have two workbooks.They have been opend.Now,I want to copy content of A1 in book2.xls,and paste A1 in book1.xls.
Must use worksheet's codename.
Unfortunately,the code isnot work!
Thanks for any help!:doh:

Aussiebear
10-28-2007, 02:09 AM
Fanjy, your file is corrupted. I can't download it without the dreaded message

fanjy
10-28-2007, 02:15 AM
first workbook:

fanjy
10-28-2007, 02:16 AM
another workbook:

Bob Phillips
10-28-2007, 02:52 AM
You cannot do that. Codename can only refer to the activeworkbook, so using a codename from another just fails.

fanjy
10-28-2007, 04:23 AM
thank you!

Norie
10-28-2007, 06:36 AM
Why must you use the codename?

There's only 1 worksheet in the second workbook.:confused: