VBA Code Required to autofill formulated column according to the adjacent column

Hi Team,

I have values in suppose column A (can be upto any row number) and there is a formula in B2.

Can you help me with a code that would count the rows in Column A and then would autofill B2 upto the last row adjacent to column A??

I hope I was able to frame my query completely.




Thanks,

Bonny Tycoon

I understand the code to count column A

Please Login or Register  to view this content.

But then how should I get Column B autofilled till that range??



Thanks,

Bonny Tycoon

I tried on my own and got the required code and output.

Closing Thread..



Thanks,

Bonny Tycoon

hey JosephP,

Thanks mate.. To tell You thats wht I got..

I cant rep myself for finding it out.. BUt glad to see a similar response.. You deserve some rep. .., Here you get it...





Thanks,

Bonny Tycoon

Hey Josephp,

I had another one too

Please Login or Register  to view this content.

Thanks,

Bonny Tycoon


**If I was able to help please click the small star icon at the bottom left of my post **