Sub 表デザイン自動適用()
'#########################################################
'# マクロ名 :
'# 機能 :
'# 作成者 :
'# 作成日 :
'# 変更履歴 :
'# 変更日 :
'#########################################################
'変数を宣言
Dim start_row As Integer '選択範囲の開始行を宣言
Dim end_row As Integer '選択範囲の終了行を宣言
Dim start_column As Integer '選択範囲の開始列を宣言
Dim end_column As Integer '選択範囲の終了列を宣言
'表を選択
ActiveCell.CurrentRegion.Select 'アクティブセルの表範囲を選択
'変数に表選択範囲を代入
start_row = Selection(1).Row
end_row = Selection(Selection.Count).Row
start_column = Selection(1).Column
end_column = Selection(Selection.Count).Column
'表に罫線を描画
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft) '表の左部に細い線
.LineStyle = xlContinuous
End With
With Selection.Borders(xlEdgeTop) '表の上部に細い線
.LineStyle = xlContinuous
End With
With Selection.Borders(xlEdgeBottom) '表の下部に細い線
.LineStyle = xlContinuous
End With
With Selection.Borders(xlEdgeRight) '表の右部に細い線
.LineStyle = xlContinuous
End With
With Selection.Borders(xlInsideVertical) '表の内縦に細い線
.LineStyle = xlContinuous
End With
With Selection.Borders(xlInsideHorizontal) '表の内横に細い線
.LineStyle = xlContinuous
.Weight = xlHairline
End With
Range(Cells(start_row, start_column), Cells(start_row, end_column)).Select '表範囲のヘッダを選択
With Selection.Borders(xlEdgeBottom) '表範囲のヘッダの下部線を二重線
.LineStyle = xlDouble
.Weight = xlThick
End With
With Selection.Interior '選択範囲のヘッダを緑色に変更
.ThemeColor = xlThemeColorAccent6
.TintAndShade = 0.399975585192419
End With
'表の横幅を自動調整
Range(Cells(start_row, start_column), Cells(end_row, end_column)).EntireColumn.AutoFit
End Sub