Page 1 of 1

Copy format from one cell and apply to area

Posted: Mon Jan 09, 2017 2:50 pm
by 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

Re: Copy format from one cell and apply to area

Posted: Tue Jan 10, 2017 11:18 am
by larsa
Hello

Use CopyCell This will copy any formatting.