Transfer the colorindex of a cell to another, without using paste or pastespecial
Hello people,
I would like to transfer the format of the cells (value and colorindex)
"without" using pastespecial or paste command. I have written a code
like this
Sub test()
Sheet2.Range("A1:A15").Value = Sheet1.Range("A1:A15").Value
Sheet2.Range("A1:A15").Interior.ColorIndex =
Sheet1.Range("A1:A15").Interior.ColorIndex
End Sub
Values are transferred but not the colorindex. How could the coloindex
of the cells be transferred without using the pastespecial command?
Please provide your help..
Thanks,
Thulasiram
|