Have a sheet with colunms First, Last, Address, City, State, Zip, Email. Some cells in the Email column contain a random value i.e. Z9A1BNSZ.

Looking for a Macro that will delete all rows (records) that do not contain proper email addresses i.e. email@email.com.

Any help would be appreciated.

Thanks.

Davbuf