error 1004 delete method of range class failed

[Edu Vargas]

Hola:
Creé una macro que se vincula con SAP, en donde de manera automática exporta de SAP un reporte en excel, para finalmente abrirlo y editarlo, ya saben... eliminar filas, eliminar columnas, etc... Me está generando un error en una operación donde no debería estarse deteniendo:

Sheets("VL06O_OTIF").Select
Rows("1:1").Select
Selection.Delete Shift:=xlUp

Ayuda por favor.

 

[Micron]

To responders: I think English version is here (should be one post?).

error 1004 delete method of range class failed

Hello guys. I have created a macro linked to a script in SAP, it exports in an automated way a report directly from SAP, and once it gets done this report is edited in Excel. I got a simple error in an operation that shouldn't be stopping my macro: Sheets("VL06O_OTIF").Select...

www.mrexcel.com