Range("B100").Select
Selection.Copy
Windows("Book2").Activate
Range("B100").Select
ActiveSheet.Paste

--
Ian
--
"Dileep Chandran" wrote in message
ups.com...
Hello everybody,

Is it possible to select a text from B100 of Book1.xls and paste it to
B100 (which already has a text) of Book2.xls?

Assume both books are open.
Assume B100 of Book1 contains "XYZ" and B100 of Book 2 contains "ABCD"
So the macro should run so as to change B100 of Book 2 "ABCD - XYZ"

Can anyone help?
Thanks and Regards
-Dileep