It wasn't meant to be funny.
"Most of the VGA cables only have 14 pins"
That's because it's the standard. Pin-9 is not used.
The VGA/VESA/DDC2 standard uses pin-9 but it's described as "optional +5V output from graphics card". It's used to auto-detect the the screen resolution supported by the monitor.
"According to pinouts.ru, the VGA DDC2 standard uses pins 9, 12 and 15 to communicate the capable screen resolutions of the device connected. So, if pin 9 is missing, then you will get a standard set of resolutions in your Windows display settings."
Assuming you're asking about a CRT monitor, a new cable probably costs as much or more than the monitor's worth.