That code does not need to be a function because it does not return a
result, which is the normal practice for a function. Also, I don't think you
should be using it within a worksheet as again it isn't returning a result,
so nothing shows in the cell.

I think you should be calling it from within another macro, probably from
within the Workbook_Open event.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"peter.thompson"
<peter.thompson.21ma1y_1137229201.0676@excelforu m-nospam.com wrote in
message news:peter.thompson.21ma1y_1137229201.0676@excelfo rum-nospam.com...

Thanks Carim, my learning is moving up a notch!

Cheers

Peter


--
peter.thompson
------------------------------------------------------------------------
peter.thompson's Profile:
http://www.excelforum.com/member.php...o&userid=29686
View this thread: http://www.excelforum.com/showthread...hreadid=501319