Dim strfix() As String
Dim strfix1() As String
With MSHGrid4
strfix1 = Split("貨號|數量|單位|絲印|絲印|切布|切布|染色|染色|壓紋|壓紋|塑膠|塑膠|射骨|射骨|定型|定型|手撼|噴油|植毛|點油|剪枝|裝配", "|")
strfix = Split("貨號|數量|單位|模具|碼數|模具|扎數|模具|扎數|模具|扎數|模具|數量|模具|數量|模具|數量|手撼|噴油|植毛|點油|剪枝|裝配", "|")
.Cols = 23
.FixedRows = 2
.FixedCols = 0
.MergeCells = flexMergeRestrictColumns
For i = 0 To 22
.TextMatrix(0, i) = strfix1(i)
.TextMatrix(1, i) = strfix(i)
.MergeCol(i) = True
Next i
.MergeCells = flexMergeRestrictRows .MergeRow(0) = True '合并固定行
.MergeRow(1) = True '
.ColWidth(0) = 1500
.ColWidth(1) = 600
For i = 2 To 23
.ColWidth(i) = 600
Next
.ColAlignment(-1) = 4
For i = 1 To 4
.ColAlignment(i) = 1
Next
.ColAlignmentFixed = 4
End With
Dim strfix1() As String
With MSHGrid4
strfix1 = Split("貨號|數量|單位|絲印|絲印|切布|切布|染色|染色|壓紋|壓紋|塑膠|塑膠|射骨|射骨|定型|定型|手撼|噴油|植毛|點油|剪枝|裝配", "|")
strfix = Split("貨號|數量|單位|模具|碼數|模具|扎數|模具|扎數|模具|扎數|模具|數量|模具|數量|模具|數量|手撼|噴油|植毛|點油|剪枝|裝配", "|")
.Cols = 23
.FixedRows = 2
.FixedCols = 0
.MergeCells = flexMergeRestrictColumns
For i = 0 To 22
.TextMatrix(0, i) = strfix1(i)
.TextMatrix(1, i) = strfix(i)
.MergeCol(i) = True
Next i
.MergeCells = flexMergeRestrictRows .MergeRow(0) = True '合并固定行
.MergeRow(1) = True '
.ColWidth(0) = 1500
.ColWidth(1) = 600
For i = 2 To 23
.ColWidth(i) = 600
Next
.ColAlignment(-1) = 4
For i = 1 To 4
.ColAlignment(i) = 1
Next
.ColAlignmentFixed = 4
End With
换成这样似乎可以的:
strfix1 = Split("貨號|數量|單位|手撼|噴油|植毛|點油|剪枝|裝配|絲印|絲印|切布|切布|染色|染色|壓紋|壓紋|塑膠|塑膠|射骨|射骨|定型|定型", "|")
strfix = Split("貨號|數量|單位|手撼|噴油|植毛|點油|剪枝|裝配|模具|碼數|模具|扎數|模具|扎數|模具|扎數|模具|數量|模具|數量|模具|數量", "|")但可能不合你的要求.
就可以了............
'.MergeCells = flexMergeRestrictRows .MergeRow(0) = True '合并固定行
.MergeRow(1) = True '
.................