| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 1004 - Autofill
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| run time error 1004 general odbc error excel 2003 vba | Excel Programming | |||
| Run-time error '1004': AutoFill method of Range class failed | Excel Discussion (Misc queries) | |||
| Run-time error '1004': AutoFill method of Range class failed | Excel Discussion (Misc queries) | |||
| Run-Time error 1004 in Autofill method of rangle class failed | Excel Programming | |||
| Error when cell A1 is not active and xlInsideVertical border formatthrowing error 1004 | Excel Programming | |||
Threaded Mode
