Thread: Storing Formats of cells in Array and reapply later
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
  
Posts: 1,549
Default Storing Formats of cells in Array and reapply later

"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
Reply With QuoteReply With Quote