thank you very much, this is exactly what I need. However I still hav
a few questions.

first off I'm supposed to enter your code as a module, right?

Second can I activate that module anywhere in the sheet, and I would d
so by typing =module1

If it is supposed to be a module, and I can type =module anywhere i
the sheet to activate it then I have one more questions

When I run the module excel gives me an error of #Name which it call
an invalid name error

--
Tar
-----------------------------------------------------------------------
Taru's Profile: http://www.excelforum.com/member.php...fo&userid=3549
View this thread: http://www.excelforum.com/showthread.php?threadid=55266