Excel里面删除一行,
最左边的固定列的行号自动向上补齐,
即删除了一行后各行号之间仍然是连续的.我已经用最苯的办法了,但是速度不能接受啊
dim a '删除的那一行的行号
for i=a+1 to MSFlexGrid1.Rows
MSFlexGrid.Row=i
MSFlexGrid1.col=0
MSFlexGrid1.Text=CStr(i)
Next
最左边的固定列的行号自动向上补齐,
即删除了一行后各行号之间仍然是连续的.我已经用最苯的办法了,但是速度不能接受啊
dim a '删除的那一行的行号
for i=a+1 to MSFlexGrid1.Rows
MSFlexGrid.Row=i
MSFlexGrid1.col=0
MSFlexGrid1.Text=CStr(i)
Next
Dim b as Integer
b=MSFlexGrid1.Rows
for i=a+1 to b
MSFlexGrid1.TextMatrix(i,0)=i
Next
with MSFlexGrid1
.Redraw = False
lngRows=.Rwos
For lngRow=.RowSel+1 To lngRows
.TextMatrix(lngRow,0)=lngRow-1
Next .RemoveItem .RowSel
.Redraw = True
End with
with MSFlexGrid1
.Redraw = False
lngRows=.Rows
For lngRow=.RowSel+1 To lngRows
.TextMatrix(lngRow,0)=lngRow-1
Next .RemoveItem .RowSel
.Redraw = True
End with
Dim lngRows as long ,lngRow as long
with MSFlexGrid1
.Redraw = False
lngRows=.Rows
For lngRow=.RowSel+1 To lngRows-1
.TextMatrix(lngRow,0)=lngRow
Next .RemoveItem .RowSel
.Redraw = True
End with