So had Prince Charles died without producing any sons - on the the Queen's death - would Prince Andrew have then become king?

Or if Prince Charles's current 'heirs' were shown not to be his sons?