新聞財經娛樂♬資訊 News Economy

EntireRow.delete in VBA

Suppose it should work, but sometimes, I tried entire.delete is working but sometimes it is not

If using looping, it cost long long VBA running time  
For r = 55 To 60000
  Rows(r).EntireRow.Delete
Next r

Suppose it should work, but sometimes, I tried entire.delete is working but sometimes it is not

If using looping, it cost long long VBA running time  
For r = 55 To 60000
  Rows(r).EntireRow.Delete
Next r

Suppose it should work, but sometimes, I tried entire.delete is working but sometimes it is not

If using looping, it cost long long VBA running time  
For r = 55 To 60000
  Rows(r).EntireRow.Delete
Next r

Suppose it should work, but sometimes, I tried entire.delete is working but sometimes it is not

If using looping, it cost long long VBA running time  
For r = 55 To 60000
  Rows(r).EntireRow.Delete
Next r

Suppose it should work, but sometimes, I tried entire.delete is working but sometimes it is not

If using looping, it cost long long VBA running time  
For r = 55 To 60000
  Rows(r).EntireRow.Delete
Next r

Suppose it should work, but sometimes, I tried entire.delete is working but sometimes it is not

If using looping, it cost long long VBA running time  
For r = 55 To 60000
  Rows(r).EntireRow.Delete
Next r

Suppose it should work, but sometimes, I tried entire.delete is working but sometimes it is not

If using looping, it cost long long VBA running time  
For r = 55 To 60000
  Rows(r).EntireRow.Delete
Next r