sorry about the wrapping, I looked at rule two and didn't see anything that referenced "Wrapping"...and I actually am a neophyte at this.

Not sure what you mean by using the "If"

I suppose too that I mis-used the workd macro. Basically I have a worksheet populated with data from a Access file and on each row there is a cell that calls the function I mentioned. Works like any other function in that I pass parameters and expect a value to be returned.

Again, the problem is that even tho there is data in the cells that are referred to when it drops into the function some of those values are not there. I'd like to know why and how to fix it.

Thoughts?