Can a Macro generate a report?

I've just written my very first macro and I need a little bit of help....

My company receives huge excel spreadsheets from our clients containing lots of customer information. One of the fields is email addresses, my job is to make sure these email addresses are formatted correctly (replacing things like , for . and .couk. for .co.uk) .

This takes ages, as there are hundreds/thousands of emails, so I have written a very basic macro to speed this up, and it works really well.

Is there a way that I can get the macro to generate some kind of report after/while running, to either show me a list of errors it has corrected or at least the total number of errors corrected?

thanks in advance

thanks for the reply, I'm probably going to need a bit more help (I am a COMPLETE newbie at this) ...

my macro is listed below, whereabouts do I add the code you provided?

Please Login or Register  to view this content.

thanks again

Please see the attached file.

I have made some changes to your code.
The report will be generated leaving 2 rows after your data ends.