Dragging down formulas to last row in reference to the next column

[Maniac03]

I would like to drag down the formula from the last cell in Column A in reference to the last row in column B.

E.g My last data in Column A104 (code to select the last cell and this can vary from time to time the report is updated)
Column B has data till B142. I want to drag A104(contains formulas) down to A142.

Here is what I have but Selection Autofill doesnt work.

Range("A2").End(xlToRight).Select
Range("A2").End(xlDown).Select
Selection.AutoFill Destination:=Range("A3:A" & Cells(Rows.Count, "B").End(xlUp).Row), Type:=xlFillDefault

Any help, please?

Thank you.

[millz]

Hello, welcome to the forums. Please remember to use code tags when posting code in the future.

Try something like this:

Please Login or Register  to view this content.