Copy Range Style Only

Copy Range Data Only and Copy Range Data with Style explained how to copy data from a range to another with or without formatting. It is also possible to copy only the formatting of the range. This article shows how.

Copy Range Style Only

This example creates a workbook, populates it with data and copies a range’s style only.

1. Create a range.
2. Create a style object with specified formatting attributes.
3. Apply the style formatting to the range.
4. Create a second range of cells.
5. Copy the first range’s formatting to the second range.