Storing Formats of cells in Array and reapply later

[Ian]

Hi there!

Is it possible to store e.g. 10 cells' format in an array of 10 e.g. F(9)
and then reapply those 10 cells ' formats to other 10 cells later?

Thank you very much!

Ian

 

[Jim Cone]

"Yes, but"...
You may be happier if you copy the formats to a hidden range
and then use that range as the formatting source.
--
Jim Cone
Portland, Oregon USA



"Ian"
wrote in message
Hi there!
Is it possible to store e.g. 10 cells' format in an array of 10 e.g. F(9)
and then reapply those 10 cells ' formats to other 10 cells later?
Thank you very much!
Ian

 

[Ian]

Hi Jim!

Thanks for the reply.

Yes, I may do that but unfortunately I need to do it on hundreds of cells
maybe, so it may be wise to do it in arrays and make it neat using coding for
long term.

best regards,
Ian

 

[Jim Thomlinson]

Define formats... Number, Colour, Font, Border, Alignment and Wrap,
Conditional, ... The issue you are up against is the number of different
formating options a cell can have. I would go with Jim's suggestion of
copying the formats to a hiden range and let XL handle all of the details. It
will be much neater in the end...