我写宏遇到问题,请帮我改一下!
void Macro2()
{
/**
*录制宏 日期:2004-12-2 作者:宋永健
*/
Worksheet sheet = Application.getWorkbooks().getActiveWorkbook().getWorksheets().getActiveWorksheet();
Cell cell = sheet.getActiveCell();
int row = cell.getRow();
int column = cell.getColumn();
sheet.select(1,column,row,column);
/**
*选择以上单元格
*/
ActiveRange.setBorderStyle(BorderAndShadingConstants.BOTTOM_BORDER);
ActiveRange.setFontBold(true);
ActiveRange.setHorizonalAlignmentCenter();
ActiveRange.setFontName("华文楷体");
ActiveRange.setFontSize(72.0);
Range range = sheet.getActiveRange();
int startRow= range.getStartRow();
int startColumn = range.getStartColumn();
int endRow = range.getEndRow();
int endColumn = range.getEndColumn();
ActiveWorksheet.select(startRow:endRow);
ActiveRows.setRowHeight(9.39);
ActiveWorksheet.select(startColumn:startColumn+1);
ActiveColumns.setColumnWidth(20.00);
上面加颜色的地方怎么改才对呢?我是菜鸟,请高手指教