Hi,
This sheet is to perform a raffle, with people's names assigned 1 to 100 in the range TargetRg. It colors random cells orange as a build up, then selects a last random cell and colors it green.
The code I'm currently using is below. It works exactly how I want it to, until the last part. I...