Transpose Color Formatting to Seperate Worksheet

B

Bryan

I am using the transpose function to send arrays of colored cells with
data from one worksheet to another in the opposite orientation. The
data is transposing and updating correctly, but I lose any color/cell
formatting on the way. Are there any VBA or Macros to have the
formatting follow as well, keeping in mind that the cells are now on
the opposite orientation?
 
D

DTB

Try using paste special instead of the Transpose() function. It's under the
Edit menu. Be sure to select Paste All and Transpose at the bottom of the
dialog.
 
Top