the most recent model I attached is the one that is correct. I just want to figure out how to use VBA to extract the border colors from the team name cells in the NBA tab and how to somehow blank the last drop down option (in B35) when there is nothing in A35.