Copy/Paste range not copying format

Because the “What to copy” property has options of All, Values, Formulas, and Format…I would expect “All” to copy everything including the format. Except all I’m getting is the raw data without formatting.