macro that copies all values of columns in column A

[1234]

Hi,

I need a macro that pastes all values from columnas B and C in A

Thanks in advances

Merry christmas

 

[Otto Moehrbach]

You don't need a macro. In A1 put =B1&C1 and drag down as far as is needed.
If you really want a macro, use this: HTH Otto
Sub FillColA()
Dim c As Long
c = 1
Do Until Cells(c, 2) = ""
Cells(c, 1) = Cells(c, 2) & Cells(c, 3)
c = c + 1
Loop
End Sub

 

[Don Guillett]

side/side or b below a??

 

[1234]

Hi,
I think I maybe didn´t explain everything well. I need B values under
A values, and C values under the B values pasted on A values. The
macro and formula concatenates values B and C and that´s not what I´m
looking for. Thanks anyway.

 

[Don Guillett]

for i=2 to 3 ' col 2 to col 3
lr=cells(rows.count,"a").end(xlup).row+1
columns(i).copy cells(lr,"a")
next i

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Hi,
I think I maybe didn´t explain everything well. I need B values under
A values, and C values under the B values pasted on A values. The
macro and formula concatenates values B and C and that´s not what I´m
looking for. Thanks anyway.