in reply to How to set bold /underline to perticular cell in excel?

Some extra code snippets :)
$Sheet2->Range("B2:D2")->Merge; $Sheet2->Range("B2:D2")->Font->{Bold} = "True"; $Sheet2->Range("A4:E11")->Select; $Sheet2->Range("A4:E11")->Borders(xlEdgeLeft)->{LineStyle} = xlContin +uous; $Sheet2->Range("A4:E11")->Borders(xlEdgeTop)->{LineStyle} = xlContinu +ous; $Sheet2->Range("A4:E11")->Borders(xlEdgeRight)->{LineStyle} = xlConti +nuous; $Sheet2->Range("A4:E11")->Borders(xlEdgeBottom)->{LineStyle} = xlCont +inuous; $Sheet2->Range("A4:E11")->Borders(xlInsideVertical)-> {Weight} = xlThi +n; $Sheet2->Range("A4:E11")->Borders(xlInsideHorizontal)-> {Weight} = xlT +hin; $Sheet2 -> Range("A4:E4") -> {Columns} -> Autofit; $Sheet2 -> Range("A4:E4")->{ColumnWidth}->Autofit; #####---------COLORS TO USE IF NEEDED--- $Sheet2->Range("C7:C7")->Interior->{ColorIndex} = 4; $Sheet2->Range("C8:C8")->Interior->{ColorIndex}= 37; $Sheet2->Range("C9:C9")->Interior->{ColorIndex} =3;
Raghu