I have some code that makes use of a variant to transfer a column of
data on one worksheet to a diagonal set of cells on another sheet.

I basically loop and assign the column data to the diagonals to the
variant, then equate the variant back to the new sheet (as a whole
block).

Here's my issue: I have formulas on the new sheet that I would like to
retain (that are on the off diagonals), but when I assign the variant to
the new sheet (since it's the complete block), it's overwriting the
formulas.

Is there a way to put the values on the sheet and retain the formulas?
Maybe creating the variant as a diagonal range in the first place? I
wasnt having much luck with that.

Thanks for the help!


---
Message posted from http://www.ExcelForum.com/