Extracting Email Addresses

  • Thread starter Thread starter Jumbo
  • Start date Start date
J

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
 
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
 
Back
Top