Moving data from one cell to another

[abmorgan]

Hi all.

It is the first time I have posetd in here and am very interested in
learning more about VB for Excel.
Firstly, anyone know the best way to start learning? Are there any
books you could recommend? or websites even?

Secondly, I am wondering how to do the following,

I need a macro to move data from one cell to a cell two to the right,
but rather than copy and pasting over the top of the cell the data from
the cell on the left gets added onto the end of the destination cell

For example

[red][][book] >>>>>>>> [ ][][red book]

I am looking for it to work with over areas of cells or just single
cells?

Is it possible?
I don't really know where to start.

Any help appreciated

Anthony

 

[Carim]

Anthony,

From what you are describing, concatenation would do the work ... you

don't a macro ...
e.g. =A1&" "&C1

HTH

Carim

 

[abmorgan]

Hiya,

Yeah I have just started getting to grips with concatenation, but I
want to avoid inputting a formula everytime. I don't know how to get a
macro to give the value of that formula. Also I am looking to replace
[book] by [red book] so i can't input into this cell

Ant

 

[Carim]

If you really need a macro, to take contents from C3 and D3 into F3 :

Range("F3").FormulaR1C1 = "=RC[-4]&RC[-3]"

HTH

Carim