Rows - .EntireRow.Delete - 1004 Error, but rows ARE deleted

[Cosmos75]

I have a simple delete code line that gives me a 1004 error (Delete method of Range class failed), BUT the rows are deleted! The error causes the remaining code not to execute because of the error handling code I have which give a msgbox explaining that an error code occurred the exits.

Any idea what is causing the error? The rows that are being deleted are the correct rows, rows 37245:38416.

.Rows(i & ":" & iEnd).EntireRow.Delete

 

[MARK858]

Do you get the same error with just

.Rows(i & ":" & iEnd).Delete

 

[Cosmos75]

Do you get the same error with just

.Rows(i & ":" & iEnd).Delete

I did not try that. I'll give it a whirl and let you know! Thanks!