Extracting Email Addresses

[Jumbo]

Hello all,
I need some help on how to extract email addresses from a worksheet that
contain cells with either text or an email address. The problem is that
email addresses are all over the worksheet. As of now I AutoFilter for each
column then a copy/paste onto a new worksheet, but it take me for ever. Can
someone help me to work faster ?
Thank you
Philippe

 

[Ron de Bruin]

Hi Jumbo

Try this one
http://www.rondebruin.nl/find.htm#Copy

 

[Jumbo]

Hi Ron and thank you so much,
I just needed to change the size of the array for my own range and here we
go things are flying in a matter of nanoseconds (not even), so fast and
powerful, thanks a lot Ron I appreciate your help.
I will take sometime to investigate your site, I love to learn...so great.
Thank you
Philippe

 

[Ron de Bruin]

Hi Philippe/Jumbo

You are welcome

Thanks for the feedback