Sub 颜色()
Dim i As Long, j As Long, k As Long
Dim mycell As Range
Dim arr As Long
Set mycell = Application.InputBox(prompt:="选取单元格范围", Type:=8)
i = mycell.Cells.Count
j = mycell.Column
k = mycell.Row
Cells(j, k).Interior.Color = 15
End Sub
我想将选取区域的第一个单元格填充成红色,总不成功,请求帮助!!!