Deleting cells with a -0-

[dignityy]

I have created a macro to copy/paste/and sort data from one sheet into another but I need to know how to write the VBA to look at the column that was just sorted and delete all Rows that have a zero in this column. Can someone please help.

Thanks

 

[SkipVought]

Hi,

Turn on the macro recorder.

AutoFilter - Criteria 0

Select rows to delete

Edit/Delete

Remove filter

check out VB code

Skip,

_[red][/red]