Returning the value of a cell

[mikecrowston]

I have a formula [TABLE="width: 409"]
<colgroup><col></colgroup><tbody>[TR]
[TD]=(A3&"."&B3&"@test.co.uk") which returns mike.crowston@test.co.uk
I would like to copy the returned value to another cell[TABLE="width: 409"]
<colgroup><col></colgroup><tbody>[TR]
[TD][TABLE="width: 409"]
<colgroup><col></colgroup><tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[jproffer]

If that is in A1, then in A2 put: =A1 .

I'm assuming that's not what you mean, since if you can come up with your formula, you could surely figure that out.

If you mean you want to have the actual text entered into a different cell, via VBA then maybe a ws change event with:

If Not Intersect(Target,Range("A1")) Is Nothing Then Range("A2").Value = Range("A1").Value

Or something like that. I'll do a little testing when I get to work. (no excel available at home)

 

[jproffer]

Yea, that didn't act like I thought it would at all

Would it work if you just did it on calculation?

Private Sub Worksheet_Calculate()
    [B1].Value = [A1].Value
End Sub