| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro - Inserting text to a cell already containg text
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro - Inserting text to a cell already containg text
You have at 2 responses in microsoft.public.excel
-- 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro - Inserting text to a cell already containg text
Ian, I didnt get what I need excatly from searching that group. Can you help me out? -Dileep Chandran |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro - Inserting text to a cell already containg text
Sorry, I meant microsoft.public.excel.misc where you posted your original
message. -- Ian -- "Dileep Chandran" wrote in message oups.com... Ian, I didnt get what I need excatly from searching that group. Can you help me out? -Dileep Chandran |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro - Inserting text to a cell already containg text
Thanks, Ian. I got it.....
|
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro - Inserting text to a cell already containg text
Shame it was wrong :-(
-- Ian -- "Dileep Chandran" wrote in message ups.com... Thanks, Ian. I got it..... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell References | Excel Discussion (Misc queries) | |||
| Adding a Function to a cell when inserting a row from a macro | Excel Worksheet Functions | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions | |||
Linear Mode
