Copy and Paste in column b if column a has contents

[redkilner]

I have a list of data with a formula in column b. I only want that formula in rows where there is something in column a. My data starts at row 12 and I would like to copy the formula in B12 down through the last row that there is something in column A... using VBA / Macro.

Thanks in advance!

[JieJenn]

try

Range("B12").AutoFill Range("B12:B" & Cells(Rows.Count, 1).End(xlUp).Row)