Efficient way to transpose values from one sheet to another

[FallingDown]

Hi everyone

I have approx 50 values in a sheet, that need to be fed to another sheet
My macro does this for font color, interior color and strikethrough formatting
I am working with ranges, where one column = 1 range

Please Login or Register  to view this content.

I have defined all of this one by one - but surely there has to be a better way to do this. Can anyone suggest something?

Thanks
FD

[sysss]

Hi,

really don't understand. With that piece of code you are applying format of one range to another range, not the values.
What about range("A").copy and range("B").pastespecial xlpasteformats?

s.