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...
--
HTH...

Jim Thomlinson


"Ian" wrote:

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