D
diepvic
Hi,
I've got a macro like below:
lngLastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row
Range("M2:X2").Select
Selection.AutoFill Destination:=Range("M2:X" & lngLastRow)
When I run the macro, I come up with error 1004 - Autofill method of range
class failed.
the lngLastRow is 2.
Can anyone help me?
Thanks
I've got a macro like below:
lngLastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row
Range("M2:X2").Select
Selection.AutoFill Destination:=Range("M2:X" & lngLastRow)
When I run the macro, I come up with error 1004 - Autofill method of range
class failed.
the lngLastRow is 2.
Can anyone help me?
Thanks