glad to help. UDF functions need to go in a general module. In the
ThisWorkbook module there is code that will act of EACH sheet in the
workbook. Take a look.

--
Don Guillett
SalesAid Software

"lopsided" wrote in message
...
Hi Don,

That worked fine - i didnt realise this code needed to go in the
worksheet code, i kept trying to put coding in a separate module!

Many thanks,

Tom


---
Message posted from http://www.ExcelForum.com/