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