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

Dim Rws As Long, Rng As Range
Rws = Cells(Rows.Count, "A").End(xlUp).Row
Set Rng = Range(Cells(1, 1), Cells(Rws, 1))

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



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

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

Closing Thread..



Thanks,

Bonny Tycoon

Hey Josephp,

I had another one too

    Dim LastRow As Long
    LastRow = Cells(Rows.Count, "A").End(xlUp).Row
    Range("B2").AutoFill Destination:=Range("B2:B" & LastRow)

Thanks,

Bonny Tycoon


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