セルã®æ“作(罫線ã®è¨å®š)：VBA講座Borderオブジェクトã¨Bodersコレクション セルã«ç½«ç·šã‚’引ãã«ã¯ã©ã†ã—ãŸã‚‰ã„ã„ã§ã—ょã†ï¼Ÿã„ã¤ã‚‚ã®ã‚ˆã†ã«ãƒžã‚¯ãƒè¨˜éŒ²ã—ã¦ã¿ã¾ã™ã€‚次ã®ã‚³ãƒ¼ãƒ‰ã¯ã€ã‚»ãƒ«ç¯„囲A1:C3ã«æ ¼å罫線を引ã„ãŸæ“作を記録ã—ãŸã‚‚ã®ã§ã™ã€‚ツールãƒãƒ¼ã®[罫線]ボタンã§æ“作ã—ã¾ã—ãŸã€‚ Sub Macro1() Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagonalUp).LineStyle = xlNone With Selection.Borders(xlEdgeLeft) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeTop) .LineStyle
モダンãªVBAã®æ›¸ãæ–¹
イミディエイトウインドウã§å³åº§ã«ãƒ‡ãƒãƒƒã‚° - EXCEL-LENCE web
{{#tags}}- {{label}}
{{/tags}}