error 1004 delete method of range class failed

[Edu Vargas]

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
Rows("1:1").Select
Selection.Delete Shift:=xlUp

What should I do? Excel 2016

 

[Joe4]

Which line of code is highlighted when that error occurs (hit the Debug option and see which line of code is highlighted)?

Are you ceratin you have a sheet named "VL06O_OTIF"?
If the error is occurring on that line, it means that you do not.
Note that any extra spaces or other characters will cause a non-match.

 

[Edu Vargas]

Which line of code is highlighted when that error occurs (hit the Debug option and see which line of code is highlighted)?

Are you ceratin you have a sheet named "VL06O_OTIF"?
If the error is occurring on that line, it means that you do not.
Note that any extra spaces or other characters will cause a non-match.

Hello Joe.
The error occurs in the last líne:
Selection.Delete Shift:=xlUp

Yes there is a sheet with that name.

 

[Joe4]

Do you have merged or protected cells in row 1?

By the way, you original code can be simplified to:

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

There is usually no need to select ranges in order to work with them.

 

[Edu Vargas]

Do you have merged or protected cells in row 1?

No Joe, this is a new sheet with info from SAP. No merged nor protected cells. Indeed I am trying to delete that row manually and it doesn't get deleted

 

[Joe4]

There must be something in row one preventing it from being deleted.
If the row is not hidden, protected, or contain merge cells, it should work.

What happens if you manually try to delete row one on that sheet?
Are you able to do that?

 

[Edu Vargas]

There must be something in row one preventing it from being deleted.
If the row is not hidden, protected, or contain merge cells, it should work.

What happens if you manually try to delete row one on that sheet?
Are you able to do that?

No hidden, protected or merged cells Joe.
Nothing happens if I do it manually, just the contents get cleared, but the line is not deleted, I mean the line 2 doesn't go up.