thank you so much for this! can't believe i forgot If Then syntax and did as IIF! i knew it has been a while since i worked in code....but now I'm embarrassed LOL.

Thanks for your help!