I would like to know if there is a way to concatenate a variable.formula and variable.value.
I have written the following lines of code:
sub xyz()
dim x as string
dim y as string
x=Range("A1").Formula
y = Range("A2").Value
Range("A3").Value = x & y
End Sub
Range A1 contains a formula and its value can change according to some other cells. When I am printing the value in A3, its showing the value of "x" as just the formula instead of it curent value when concatenated with the value in A2.
Kindly help me. Thanks in Advance :)
Related:
Concatenating a variable.formula and variable.value