Hello VBA Experts !

I searched many sites and found many codes. But couldn't get the code.

What I want to achieve is this:

For example, I have 2 Columns, i.e. A and B.

In Column B, I want to write a formula, which I can. What I want to do is: it should be copied down to the last cell relative to column on the left (which is column A).

If there are 20 values in cells A1:A20, the formula in B1 should go to B20. If A1 goes up to A100, the formula in B1 should go to A100.

It's exactly the same as clicking the the fill handle in B1 and it will populate all cells relative to column A until last row of column A.

What would be the code for this:


Thanks for your kind help.