Thread: Keep original cell formatting when using transpose array formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GS[_2_] GS[_2_] is offline
external usenet poster
  
Posts: 3,514
Default Keep original cell formatting when using transpose array formula
No, no, and no! Sorry, but everything you want to do requires VBA. The
only reason the formatting transposed with PasteTranspose is because
it tagged along with Copy.

Your 2nd request also requires VBA and you'd have to specify what order
would you like the colors sorted to.

Is there some reason you can't pre-format the cells with the TRANSPOSE
formula?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


Reply With QuoteReply With Quote