Macro - Inserting text to a cell already containg text

[Dileep Chandran]

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

 

[Ian]

You have at 2 responses in microsoft.public.excel

 

[Dileep Chandran]

Ian,

I didnt get what I need excatly from searching that group. Can you help
me out?

-Dileep Chandran

 

[Ian]

Sorry, I meant microsoft.public.excel.misc where you posted your original
message.

 

[Dileep Chandran]

Thanks, Ian. I got it.....

 

[Ian]

Shame it was wrong :-(