Coventry england wrote:
When i tried to run the macro, it gave me an error.

#What error did it give you?
On which line was the error?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup