filters in VB

[mlk]

In VB, I filter on a status column for all "deleted" records and then I copy the deleted records into another spreadsheet.

In VB, how can you tell if a filter condition has been met? If there are no deleted records, I don't want to perform that step.

[VBA Noob]

Maybe an if statement

http://www.contextures.com/xlautofilter03.html#Copy

VBA Noob

[mlk]

That should do the trick. Thanks very much for your help!