Transpose Color Formatting to Seperate Worksheet

[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?

 

[Guest]

The original cells are probably using conditional formatting?

Alok

 

[Guest]

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.