Sorry Beauford.........my bad for not mentioning that the Analysis ToolPak
had to be installed. I always put it in any setup I'm using first thing,
and once it's there, I just forget about it. Glad you were able to get it
working tho, and thanks for the feedback..........

Vaya con Dios,
Chuck, CABGx3



"Beauford" wrote in
message ...

I tried the mround once and got the ##NAME error, but after your post I
did some more searching and found I had to add in the mround function.
That seems to have done though. Did I mention I hate Office....

5 stars to you.....

Thanks


--
Beauford
------------------------------------------------------------------------
Beauford's Profile:
http://www.excelforum.com/member.php...o&userid=35309
View this thread: http://www.excelforum.com/showthread...hreadid=551260