Array/Loop to Delete Rows?

[asother]

Basically I have a little of an idea how to code this but I know it doesn't work, I have this spreadsheet, I want it to follow the logic of:

If column F = "$0.00" and column D = "$0.00" then
delete the corresponding row
else

I can image it looking something like (which is completely wrong):

Please Login or Register  to view this content.

I could code it line by line for like 1000 lines, though seems a bit tedious, if anyone can help, thanks,

- Alex

[sweep]

Here ya go:

Please Login or Register  to view this content.

dave

[asother]

Thanks, I just tried this code and it doesn't seem to be working.

I put it in this macro, then ran the macro it doesn't give me any errors, but the sheet looks to be the same. I made sure that the corresponding values in column D and F are "0" (without the quotes) as well, as opposed to $0.00.

Oh also, I changed your "o" to "0" and it didn't work also.

[asother]

Oh, also your code I tried on just the second line and it deleted the entire column, I wanted it to delete the row corresponding to the column that shows 0 for F2 and D2, F3 and D3, etc... sorry for the misunderstanding.

Please Login or Register  to view this content.

If anyone can help, thanks,