I found the answer to my problem in this post:

http://www.microsoft.com/office/comm...=en-us&m=1&p=1

but I don't understand why this works when using a cell reference for
criteria. Does it work because the reference is text? If someone could
explain it to me I would appreciate it.

TIA