Hi Marcol, thanks for the info, but I'm still having a "mikewaring" moment.

I write all my modules into the "Personal.xls" worksheet so I can use them with any other worksheet.

This is mainly because my working sheets are replaced every day by that day's new download (using the same filename so we can then export to Access), hence why I can't keep macros in these worksheets.
I copied the 1st module (the function and the sub code below that) into a new module in Personal. Can I now create another module and paste the second part into this? Will this second sub run the first one when I run the second macro?
Thanks