Concatenating a "variable.formula" and "variable.value" in a Cell

[AdiK]

Hello Guys,
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

[Subverter]

You have a formula in Range("A1"), and you world like to concatenate (the formula with the value) and assign the result to Range("A3")
Just like if You have e.g: Formula Now(), So Range("A3").Value would be: "Now(), 23/11/2016 01:27:26 P.M"
Is that Right?!!!

[Doc.AElstein]

Hi AdiK

Hello Guys,
_1 I would like to know if there is a way to concatenate a variable.formula and variable.value.
_2 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.

You seem to be asking two different questions
Subverter has given you the answer to question _1

This is the answer to question_2

Please Login or Register  to view this content.

.Value and .Formula are two Properties for a Range Object

.Value will be the "value" you typically "see"
.Formula will be a string of the formula for the cell ( if it has one ) in the "column letter and row number" type convention notation
http://www.excelforum.com/showthread...=8#post4519378


Alan

P.s.
See here for example – you can see some of the Properties of the Range Object:
To get for example this for your cell A1,
_goto the VB Editor,
_1 ) Put a stop at End Sub by clicking in the margin to the left of End Sub until a round brown symbol appears in the margin to the left of End Sub
_2) Run your code – it should stop at End Sub
_ 3) Highlight Range("A1") in your code
_ 4) Hit Shift+F9 to display the Watch window
_ 5) click on the + in Watch Window to reveal Range Object Properties http://imgur.com/l8zJfmU
WatchWindowA1.JPG
http://imgur.com/Ms0nbN7
ImmediateAndWatchWindow.JPG
http://imgur.com/a/auaRM


WatchWindowA1.JPG



http://www.excelforum.com/showthread...=8#post4519378

[kasan]

Try this one

Please Login or Register  to view this content.

Doc.AElstein, I assumed that Subverter in his post clarified/described the question better than Topic Starter. Actually I don`t see multiply questions in this post.
Issue is to get formula from the cell as text + value of this formula.
So my proposal is to convert formula and value of the formula - to strings (with CStr function) and this symbol before the result "'" - just to be sure that x+y will be represented in cell as text, because if x+y is "=if(...)TRUE" than after inserting this text into a cell - excel might understand the first string symbol (=) as a start of formula and error will accure.

[Marc L]

Sub Demo()
    [A3].Value = Mid([A1].Formula, 2) & " = " & [A1].Value
End Sub 

Do you like it ? So thanks to click on bottom left star icon « Add Reputation » !

[Doc.AElstein]

....

Doc.AElstein, I assumed that Subverter in his post clarified/described the question better than Topic Starter. Actually I don`t see multiply questions in this post.
Issue is to get formula from the cell as text + value of this formula.
So my proposal is to convert formula and value of the formula - to strings (with CStr function) and this symbol before the result "'" - just to be sure that x+y will be represented in cell as text, because if x+y is "=if(...)TRUE" than after inserting this text into a cell - excel might understand the first string symbol (=) as a start of formula and error will accure.

Hi kasan.
Thanks for the clarification.

I saw two questions as the OP had written.
_2 )

.....
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" ( x= A1) as just the formula instead of it curent value when concatenated with the value in A2.(A2 is y - probably a value ..)

_1)

I would like to know if there is a way to concatenate a variable.formula and variable.value. ....

- I though this might mean the same variable
But I suspet someone has given him what he wanted - you and I gave him
2 ) I think - ( Your "'" was a good idea )
Marc L gave him 1 )

In any case I The OP should have a plenty of good info. to get what is wanted

Alan