|
哈哈,我也不会,但我知道用录制宏可以达到你的目的,我已经试过了。
Sub 跨列剧中()
Range("A2:D2,A5:D5,A15:D15,A17:D17").Select
Range("A17").Activate
ActiveWindow.ScrollRow = 2
ActiveWindow.ScrollRow = 3
ActiveWindow.ScrollRow = 4
ActiveWindow.ScrollRow = 5
ActiveWindow.ScrollRow = 6
ActiveWindow.ScrollRow = 7
Range("A2:D2,A5:D5,A15:D15,A17:D17,A20:D20,A22:D22").Select
Range("A22").Activate
With Selection
.HorizontalAlignment = xlCenterAcrossSelection
.VerticalAlignment = xlCenter
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
End Sub
[ 本帖最后由 zhc19620430 于 2009-12-6 18:07 编辑 ] |
|