How to create a macro of autofilling column D depending of column A (until blank cell is found)

[marikam]

Dear all,

I am trying to get the macro of below table:

Column A	Column B	Coulmn C	Column D
A	1	ZZ	CONCATENATE(C1;" ";B1)
B	2	YY
C	3	XX

So the purpose of the macro would be the automated fillng of the function CONCATENATE within column D until column A has data.

Thank you all in advance!

Marika

 

[Fluff]

Hi & welcome to MrExcel.
How about

Sub marikam()
   Range("D1:D" & Range("A" & Rows.Count).End(xlUp).Row).Formula = "=CONCATENATE(C1,"" "",B1)"
End Sub

 

[marikam]

Hi & welcome to MrExcel.
How about

Sub marikam()
   Range("D1:D" & Range("A" & Rows.Count).End(xlUp).Row).Formula = "=CONCATENATE(C1,"" "",B1)"
End Sub

Thank you o much!! it works perfectly!

 

[Fluff]

You're welcome & thanks for the feedback.