VBA to pull out email id's

Hi,

I need to pull out email id's, can any one help with VBA having range("a2 to a1130").

Eg :
jrt<[email protected]>
abc<[email protected]>

Output :
[email protected]
[email protected]

Perhaps a macro like this?

Please Login or Register  to view this content.

This macro will strip a dynamic range in column A and convert the striped value to an active email address. If you only want the stripped value then remove the line

Please Login or Register  to view this content.

from the macro.

Alf

Hi Alf,

Thank U Very Much......My Job done very easy.

You are welcome. Thanks for feedback and rep.
Alf

Here's another just for fun..

If your values have the same format as you showed in your example..

Please Login or Register  to view this content.

Hi Apo,

Code worked....Thank U