Hiya,
Could you get away with auto-filters instead? -(I'm not sure if you're dealing with a lot more than 1 column per sheet)
In one column, for example, you can go to toolsautofilter then click on the arrowcustomcontains @ - then you could just copy the list of email addresses to another sheet. repeat per column.
Hope that helps somewhat
Adam
Like this thread? Share it with others