No, no, and no! Sorry, but everything you want to do requires VBA. The
only reason the formatting transposed with Paste>Transpose is because
it tagged along with Copy.
Your 2nd request also requires VBA and you would have to specify what order
would you like the colors sorted to.
Is there isome reason you cannot pre-format the cells with the TRANSPOSE
Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc