書き込み
戻る次へ
1
1 / 1ページ
2
黒マス設定ボタンのマクロ
Sub KANKURO2025館黒マス設定()
XXXX = ActiveSheet.Name
For I = 2 To 21
For J = 2 To 26
If Sheets(XXXX).Cells(I, J) = "0" Then
Range(Sheets(XXXX).Cells(I, J), Sheets(XXXX).Cells(I, J)).Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorLight1
.TintAndShade = 0
.PatternTintAndShade = 0
End With
End If
Next J
Next I
End Sub
Sub KANKURO2025館黒マス設定()
XXXX = ActiveSheet.Name
For I = 2 To 21
For J = 2 To 26
If Sheets(XXXX).Cells(I, J) = "0" Then
Range(Sheets(XXXX).Cells(I, J), Sheets(XXXX).Cells(I, J)).Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorLight1
.TintAndShade = 0
.PatternTintAndShade = 0
End With
End If
Next J
Next I
End Sub
0人がいいねと言っています
0人がいいねと言っています