Deleting Row from Huge data

[ErgoTeam]

Hi have a Excel fill (size 80 MB), which have around 450000 row of data. There are few blank row randomly which i Need to remove/delete.

The code i have is as below which works fine for small data. but for huge data it gives me Overflow error.

Sub DeleteRow()

Application.ScreenUpdating = False
Dim i As Integer
Dim Lastrow As Long
Lastrow = Cells(Rows.Count, "A").End(xlUp).Row
For i = Lastrow To 1 Step -1
If Cells(i, 1).Value = "" Then
Rows(i).Delete
End If
Next
Application.ScreenUpdating = True

End Sub

Hence request you to give me code which i can you for 450000 row in a file

[Olly]

Try this:

Please Login or Register  to view this content.

Oh, and please use code tags around your code, when posting: Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

[ErgoTeam]

I am getting the below error

"Can't execute code in break mode"

Untitled233.png

[Olly]

Are you stepping through the code, with F8? Try just running the macro.

[ErgoTeam]

No. But numbers of row(more then 300000) may causing problems

[Olly]

No. But numbers of row(more then 300000) may causing problems

What makes you think that? I tested it on a dataset of 450,000 rows, with no problems...