The calculated distance (air line) between Melksham and Sheffield is approximately 142 miles respectively 228 kilometers.
By car or train, the actual journey to Sheffield is certainly longer, as only the direct route (as the crow flies) between Melksham and Sheffield has been calculated here.