private void 罫線を消す_Click(object sender, RibbonControlEventArgs e) { //選択範囲の取得 Range selection = (Range)Globals.ThisAddIn.Application.Selection; //選択範囲の数 int count = selection.Areas.Count; //複数選択範囲を配列に入れる Range[] allRange = new Range[count]; //それぞれの選択範囲について繰り返す foreach (Range r in selection.Areas) { //上端罫線を消す r.Borders.get_Item(XlBordersIndex.xlEdgeTop).LineStyle = XlLineStyle.xlLineStyleNone; //下端罫線を消す r.Borders.get_Item(XlBordersIndex.xlEdgeBottom).LineStyle = XlLineStyle.xlLineStyleNone; //左端罫線を消す r.Borders.get_Item(XlBordersIndex.xlEdgeLeft).LineStyle = XlLineStyle.xlLineStyleNone; //右端罫線を消す r.Borders.get_Item(XlBordersIndex.xlEdgeRight).LineStyle = XlLineStyle.xlLineStyleNone; //内部横罫線を消す r.Borders.get_Item(XlBordersIndex.xlInsideHorizontal).LineStyle = XlLineStyle.xlLineStyleNone; //内部縦罫線を消す r.Borders.get_Item(XlBordersIndex.xlInsideVertical).LineStyle = XlLineStyle.xlLineStyleNone; //右上り罫線を消す r.Borders.get_Item(XlBordersIndex.xlDiagonalUp).LineStyle = XlLineStyle.xlLineStyleNone; //右下がり罫線を消す r.Borders.get_Item(XlBordersIndex.xlDiagonalDown).LineStyle = XlLineStyle.xlLineStyleNone; } }