Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transfer cell value from 1 sheet to another without copy/paste? | Excel Worksheet Functions | |||
Paste vs PasteSpecial | Excel Programming | |||
paste negative time with PasteSpecial | Excel Programming | |||
PasteSpecial Paste:=ColumnWidths | Excel Programming | |||
PasteSpecial - Comments and ColorIndex | Excel Programming |