Copy format from one cell and apply to area

[GenasysCarl]

Hi,

I would like to copy a format from one cell and then apply that format to multiple cells. What is the fastest (performance) way to do this? I have looked at the FormatCells example, but cannot figure out how to get existing formats from cells in the spreadsheet.

Thanks,
Carl

[larsa]

Hello

Use CopyCell This will copy any formatting.