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?

The original cells are probably using conditional formatting?

Alok

"Bryan" wrote:

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?

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.

"Alok" wrote:

The original cells are probably using conditional formatting?

Alok

"Bryan" wrote:

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?