Delete

[komark]

Hi,
I need help with a simple code. I want to delete the entire row if a cell in that row contains no value.
Can anyone help me?

 

[PHV]

A starting point:
If ActiveCell.Value = "" Then ActiveCell.EntireRow.Delete

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AnotherHiggins]

columns("A:A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete

Replace A with whatever column you want to check against.

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[komark]

Thanks PHV..its working fine

 

[komark]

anotherhiggins
With your code how can I delete the entire rows if any cell contains the null value under the column A and C?

 

[AnotherHiggins]

What exactly is it that you are going for?

Do you want to only delete rows where both A and C are empty? or Where A or C are empty? If you want to delete rows where the entire row is empty, that can be done pretty easily. But before thinking on this, I just want to make sure I know what it is you're looking for.

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[komark]

I want to delete rows where both A and C are empty.

 

[Gavona]

Use Autofilter or advanced filter if you need to test for conditions in more than a single column. Macro recorder will give you the code.

Thanks,

Gavin