It's VBA, so go to the VBIDE (Alt-F11)

Insert a module (menu InsertModule)

Copy the code in.

In Excel, menu ToolsMacroMacros...

Select Test in the list and click Run

Voila.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"angelface" wrote
in message ...

Hi,

Thank you for taking the time to look at my problem and for sending a
response, however, I am not sure what to do with the functions you have
sent. Can you explain a little further for me and tell what I need to
do.

Many thanks



--
angelface
------------------------------------------------------------------------
angelface's Profile:
http://www.excelforum.com/member.php...o&userid=30820
View this thread: http://www.excelforum.com/showthread...hreadid=504856