Deleting rows macro

[mike02]

Hey,

I have this macro which i use to delete rows on my spreadsheet. I delete the row if the is no number in the specified column. My issue is it only deletes the empty rows on the botton, and doesnt do it throughout the spread sheet. Also, It is deleting the last row even though there is a number in the specified cells.

Please Login or Register  to view this content.

I have attached an example sheet. For some reason, it deletes the last row like i said, and iw doesnt delete the first row, which contains a null value in the specified cell

[mike7952]

Try this

Please Login or Register  to view this content.

[mike02]

thanks !!!!!!

[mike02]

how come i get an error if nothing is there?

[mike7952]

Nothing is where?

[mike02]

In the Range D, when no returns are entered. I get this error. but then i run it again right away, and i get no error:S so i close it and try it again and same thing.

Method "Union" of object'_Global' failed

Now i have never used the union function before can you explain to me what it is and what it does? and what it does for this piece of code?

Set RangeToDelete = Union(RangeToDelete, Cells(Ptr, "A")) Is where it stops

[mike7952]

Can upload the workbook giving you the issues ?

[mike02]

pardon me? what do you mean?

[mike7952]

Can you upload the workbook that the code is giving you issues

[mike02]

the work book is set up the same as the one i have upoaded earlier.

[mike7952]

I dont know cause If I download the file again and use the code I get know errors at all. Even on a blank sheet I get no error's. maybe your workbook is corrupt. Just a guess try restarting your computer and run the code. Like I said I get no errors