Relative Selection based on column to the left

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.

Try

Please Login or Register  to view this content.

Originally Posted by Thalassa

Try

Please Login or Register  to view this content.

Thanks for the code. Yes it works great.

Since I specified the cell B1 from which to go down relative to rows in column A.

How would we refer/change the code if we are in any cell and we want to go down same as above relative to column on left?

Thanks for your kind help.

Perhaps

Please Login or Register  to view this content.

For relative cell in every where.. please try this code

Please Login or Register  to view this content.

see attached file

WOW ! ! !

Great! Thanks Thalassa !

Many many thanks

Thanks for the code Dwint. Its giving an error.

Thalassa's code is working absolutely fine. Thanks for your kind reply.