Copy Range Style Only
Contents[ Hide ]
Copy Range Data Only and Copy Range Data with Style explained how to copy data from a range to another on its own or complete with formatting. It is also possible to copy only the formatting. This article shows how.
This example creates a workbook, populates it with data and copies a range’s style only.
- Create a range.
- Create a Style object with specified formatting attributes.
- Apply the style formatting to the range.
- Create a second range of cells.
- Copy the first range’s formatting to the second range.