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?