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!
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!
Fanjy, your file is corrupted. I can't download it without the dreaded message
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
first workbook:
another workbook:
You cannot do that. Codename can only refer to the activeworkbook, so using a codename from another just fails.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
thank you!
Why must you use the codename?
There's only 1 worksheet in the second workbook.