| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro - Inserting text to a cell already containg text
Correct. Sorry, I misread the OP.
-- Ian -- "JMay" wrote in message ... Isn't this code "replacing" the content of Book2 - cell B100 with XYZ, not ABCD - XYZ. How bout something more like: (Paste into a std module - Book2 Sub tester() Windows("Book2").Activate sTemp = Range("B10").Value Windows("Book1").Activate sNew = Range("B10").Value Windows("Book2").Activate sCombo = sTemp & " - " & sNew Range("B10").Value = sCombo End Sub HTH "Ian" wrote in message : 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 |
| 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 | |||
Threaded Mode
