Put it in a general module, not a sheet module

Right click on the sheet tab and select view code === No, not here

go to the VBE, insert=Module ========= place it there.



--
Regards,
Tom Ogilvy


"thanhnguyen"
wrote in message
...

Hi Bob Phillips
But when i go to worksheet and try to use that function it return
#NAME?

Please give me your email address I will send to you my funtion.
my email address is

Thanks


--
thanhnguyen
------------------------------------------------------------------------
thanhnguyen's Profile:
http://www.excelforum.com/member.php...o&userid=30502
View this thread: http://www.excelforum.com/showthread...hreadid=510475