Sorry Kevin

This works perfect, I have placed it in a module (if thats the jargon) and it
worked on all sheets

Thanks for your help

Brian

BNT1 wrote:
Thanks Kevin for the response

Copied into "this workbook". Saved, and the opened, but did not work.

Any ideas?

regards

See if the following does the trick, but save your real file under a new name
before running as this has not been tested:
[quoted text clipped - 22 lines]

Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1