Just for clarification:
That isn't VBA, it is a worksheet formula.

You should place it in the cell where you want the Yes/No.

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
Okay, very true. I'm new to vba, so elegant solutions are still
foreign to me.
Thanks for the help,
Jason