Concatenating a variable.formula and variable.value [Closed]

Question

Concatenating a variable.formula and variable.value [Closed]

Report

AdiK - Nov 23, 2016 at 06:05 AM
yg_be

Posts: 13945
Registration date: Sunday June 8, 2008
Status: Contributor
Last seen: January 19, 2021

- Nov 24, 2016 at 04:03 PM

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 :)

Concatenating a variable.formula and variable.value
Copy/paste formula to variable # of data ✓ - Forum - Office Software
Vb6 environment variables - How-To - Languages
64 bit variable in c - How-To - C Language
Undefined variable error in php - How-To - PHP
Environment variables - Articles

1 reply

Ask a question

yg_be · Answer 1 · 2016-11-24T16:03:08-0500

Answer 1 / 1

yg_be

Posts: 13945
Registration date: Sunday June 8, 2008
Status: Contributor
Last seen: January 19, 2021

4
Nov 24, 2016 at 04:03 PM

Please describe :
- the content of A1 and of A2
- what you obtain in A3
- what you expect in A3

Concatenating a variable.formula and variable.value [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!