Good Day to All.
I am using the below code to try to add a New Value (Cell 4,4) to a pre-existing value (Cell 5,4) without erasing the string details. An example of the process is shown below:
What am I missing from this code? Because its not keeping all the previously entered values/string characters in place as I am adding a new number/value
Sub Concatenate2() Dim String1 As String Dim String2 As String String1 = Cells(4, 4).Value String2 = Cells(5, 4).Value Cells(5, 4).Value = "=" & String1 & "+" & String2 Range("D4").Value = 0
Much appreciated in advance!!!!