Vandeleur, Thomas Pakenham, active 1793-1797, Lieutenant-Colonel; 8th Dragoons; Colonel 1797