Thank you SamT and p45cal for responding to my thread. Most appreciated.

I've tried the code and get a #VALUE! error returned.
I've tried modifying the "On Hold" value to reference a range cell instead, and still have the same issue.

Again, appreciate any support i can get from the group.