VBA to insert a carriage return after existing text and paste more text
29,286
Try activecell.FormulaR1C1 = activecell.FormulaR1C1 & Chr(10) & "MEASURE_1"
Related videos on Youtube
10 : 19
Copy & Paste in Excel VBA (copy, pastespecial, resize & offset)
23 : 20
Automated Text Import in Excel with File Selection - The Easy Way - VBA
09 : 46
VBA Copy and Paste text
03 : 20
Split Data Based on Carriage Returns (New Line Delimiter) in Excel - Excel Quickie 33
01 : 26
VBA to insert a carriage return after existing text and paste more text
Author by
RocketGoal
Updated on September 18, 2022Comments
-
RocketGoal over 1 year
I'm adding "Measure_1" within certain cells. This requires me to double click in the cell, go to the end of the existing text, insert a carriage return (alt+ent), and then paste in MEASURE_1. Therefore, I'm trying to automate this.
Unfortunately my VBA code below is overwriting the existing text with the example I used when recording my macro.
activecell.FormulaR1C1 = "D4)" & Chr(10) & "MEASURE_1"How do I make it say:
activecell.FormulaR1C1 = **ANY TEXT WITHOUT CHANGING** & Chr(10) & "MEASURE_1"Many thanks. Michael.