VBA - Last row & Autofill

[LeeBillington]

Hi,

So i am trying to find last column of B with data. then my current selection(Varies per day) to be autofilled down to the last column.

Not sure how to excecute it at all.

thanks

 

[alansidman]

I am guessing that you want the last "row" in column B and not the last "column" as B is a column.

To find the last row

Dim lr as long
lr = Range("B" & rows.count).end(xlup).row

You have not indicated what you wish to fill down. Are you copying the same value into all rows or is it a sequential number you wish to fill down?

 

[LeeBillington]

I am guessing that you want the last "row" in column B and not the last "column" as B is a column.

To find the last row

Dim lr as long
lr = Range("B" & rows.count).end(xlup).row

You have not indicated what you wish to fill down. Are you copying the same value into all rows or is it a sequential number you wish to fill down?

Oh sorry, yes the last row of column B, and there will be data ill manually put into the selection of like 5 cells, (formula in the selection and that needs to be autofilled down to the last row of B)

 

[alansidman]

Use VBA to Autofill a Row until the end of the number of data in another row

Hello, I need some help with the following problem: The Macro should select the first cell with the vlookup (AY2) and autofill the complete range in the..

techcommunity.microsoft.com

 

[LeeBillington]

Use VBA to Autofill a Row until the end of the number of data in another row

Hello, I need some help with the following problem: The Macro should select the first cell with the vlookup (AY2) and autofill the complete range in the..

techcommunity.microsoft.com

so im using this,
Selection.AutoFill Destination:=Range("B6:B" & Range("E" & Rows.Count).End(xlUp).Row)
Range(Selection, Selection.End(xlDown)).Select

and i keep getting the error.. autofill method of range class failed.