How to paste a value to the next range blank cell until the last value cell of adjacent column.

[lemnguyen]

Please help my a macro to copy a cell and paste (value) to the range but start from the next blank (in column C) and fill until the last value in the adjacent column (B).

Many thanks.

 

[maabadi]

Please Clarify More.
Are you want only Copy from One Cell and paste it at Range from last row at column C until last row of Column A?

 

[lemnguyen]

Please Clarify More.
Are you want only Copy from One Cell and paste it at Range from last row at column C until last row of Column A?

Dear maabadi,
Exactly as you say.

 

[maabadi]

This paste Value of A1 to Column C after last row:

Sub Test()
Range("C" & Range("C" & Rows.Count).End(xlUp).Row + 1 & ":C" & Range("A" & Rows.Count).End(xlUp).Row).Value = Range("A1").Value
End Sub

 

[lemnguyen]

This paste Value of A1 to Column C after last row:

Sub Test()
Range("C" & Range("C" & Rows.Count).End(xlUp).Row + 1 & ":C" & Range("A" & Rows.Count).End(xlUp).Row).Value = Range("A1").Value
End Sub

Perfect success! Thank you so much!

 

[maabadi]

You're Welcome & Thanks for feedback.