"Krista F" wrote in message
...
Totally makes sense... Thanks.

Do you know a good reference site/book that teaches about UDF's? I'd like
to try and disect the one you provided so I uderstand what each command
line
is doing... Then perhaps I can start tweaking it for other data I am
analyzing!

Krista

Here are a couple of links.
http://www.fontstuff.com/vba/vbatut01.htm
http://www.exceltip.com/st/Writing_Y...Excel/631.html
http://www.accountingweb.co.uk/cgi-b...m.cgi?id=35991

Here's one that many people recommend
http://www.amazon.com/exec/obidos/AS...841181-2022215

Since there are so many books on Excel, the best tip is to go to your local
Barnes&Noble and have a look at the books wich have the word VBA in their
title. You have to figure out which one seems right for you. If you do a lot
of work with Excel, you will find that a good book will pay itself in a
short period of time. Much to my surprise, I have met many accountants which
didn't know anything about UDF's. These guys came from all over the world.

/Fredrik