|
楼主 |
发表于 2012-1-18 13:18
|
显示全部楼层
Sub bb()
Dim y&
For y = 1 To 225 Step 12
With Range("L11").Offset(y, 1)
With .Font
.Name = "Arial Narrow"
.Size = 14
.Bold = True
End With
.Resize(1, 3).ClearContents
.Value = "U03-" & Format(y / 12 + 1, "00") '???
.HorizontalAlignment = xlCenter
.Resize(1, 3).Merge '合并?元格
Debug.Print .Address(0, 0); ":" & .Value
End With
Next y
End Sub
改好b11合併,但出錯了{:712:} |
|