怎样控制Excel单元格的颜色. ( 积分: 50 )

H

hhjjhhjj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2005-12-29

• #1

如题

 

H

hhjjhhjj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2005-12-29

• #2

如题

 

C

cangyu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2005-12-29

• #3

录制一下宏，然后再看它的VB代码

 

C

coscka

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2005-12-29

• #4

var Cell1,Cell2:variant;
...//略
Cell1:=ExcelApp.ActiveSheet.Cells.item[1,5];
Cell2:=ExcelApp.ActiveSheet.Cells.item[1,10];
ExcelApp.ActiveSheet.Range[Cell1,Cell2].Interior.ColorIndex:=15; //黑色
...
end

 

H

hhjjhhjj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2005-12-30

• #5

谢谢

 

H

hhjjhhjj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2005-12-30

• #6

多人接受答案了。