Run-time error '1004' - Method 'Range' of object'_Global' failed in VBA

Question

ActiveCell.FormulaR1C1 = "Y"
Range("B1").Select

Dim lastcellex As String

Range("A1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(0, 1).Select

lastcellex = ActiveCell.Address
Range("B1").Select
Selection.AutoFill Destination:=Range("B1:lastcellex")

Can anyone help me as to why I keep getting this error? I set the variable to be equal to the last cell on the range but one column over. So if the range in column A was A55, lastcellex would be B55. I am trying to make it autofill from B1:B55.

Please let me know what you guys think.

One line: Range("B1").AutoFill Destination:=Range("B1:B" & Range("A1").End(xlDown).Row+1) — Scott Craner
– Scott Craner, Commented Aug 15, 2017 at 17:41

braX · Accepted Answer · 2017-08-15 17:38:06Z

1

It should be:

Selection.AutoFill Destination:=Range("B1:" & lastcellex)

answered Aug 15, 2017 at 17:38

braX

11.9k5 gold badges24 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Run-time error '1004' - Method 'Range' of object'_Global' failed in VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related