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:
dim x as string
dim y as string
y = Range("A2").Value
Range("A3").Value = x & y
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.