Thanks for reply Biff.
This seem to take too long for excel to calculate all the cells when I
copy the formula down and then all it does is gives me odd numbers...
1, 3, 5, etc. in the cells........ Any suggestions. Wouldn't macro be
lot faster anyway?

Jay


--
sa02000
------------------------------------------------------------------------
sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747
View this thread: http://www.excelforum.com/showthread...hreadid=569539