His 'Memoirs touching the Revolution in Scotland,' published originally in 1714, reprinted 1754, and again, more correctly by the Bannatyne Club, in 1841, are invaluable as a narrative of the proceedings and negotiations of the supporters of the king in 1688-90. By his second wife, Lady Jean Carnegie, Balcarres had a daughter Anne, married to Alexander, Earl of Kellie, and afterwards to James Seton, 3rd Viscount of Kingston. By his third wife, Lady Jean Ker, only daughter of The Earl of Roxburghe, he had a son Colin, Lord Cumberland, master of Balcarres, who died unmarried in 1708, and a daughter Margaret, who married John, Earl of Wigton. By his fourth wife, Lady Margaret, eldest daughter of James Campbell, 2nd Earl of Loudoun, he had seven children, of whom four survived him - two sons, Alexander, and James, and two daughters, Eleanor, married to the Hon. James Fraser of Lonmay, Aberdeenshire, third son of William Fraser, 12th Lord Saltoun, and Elizabeth, who died unmarried.