I have a function that in each worksheet I have it call function "Exchanges". This basically autofilters the worksheet for the word "exchanges" in column D. Then it would just copy all the found rows to a new worksheet called "exchange cancel". I tried to write code to do this. Unfortunately I wrote it on the assumption that every worksheet had atleast one found row. If there wasn't any found, macro would crash. Is there a way to tell autofilter to skip if there isn't any copied rows? Thanks in Advance!