With grid
For i = 0 To .Cols - 1
If .MergeCol(i) Then curValue = data(.FixedRows, i)
lastRow = .FixedRows For j = .FixedRows + 1 To .Rows - 1
If data(j, i) <> curValue Then With xlSheet
.Range(.cells(lastRow + 1, i + 1), .cells(j, i + 1)).MergeCells = True
End With curValue = data(j, i)
lastRow = j
End If
Next j End If
Next i
End With但是range.mergecells的方法速度实在是太慢了,有没有快的方法,一次性将一列数据按内容自动合并?
For i = 0 To .Cols - 1
If .MergeCol(i) Then curValue = data(.FixedRows, i)
lastRow = .FixedRows For j = .FixedRows + 1 To .Rows - 1
If data(j, i) <> curValue Then With xlSheet
.Range(.cells(lastRow + 1, i + 1), .cells(j, i + 1)).MergeCells = True
End With curValue = data(j, i)
lastRow = j
End If
Next j End If
Next i
End With但是range.mergecells的方法速度实在是太慢了,有没有快的方法,一次性将一列数据按内容自动合并?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货