Bruce,
I found the gearbox sender unit, it has a yellow and green wires coming from it. So ill trace it through to the ECU and speedo one day.

1997 +8 4.6ltr,
MX5 ND 2.0Ltr
Rover Sterling 2.7ltr
Touareg 3.0Ltr