只是想知道为什么列删除像行删除一样需要多花 3 秒的时间来执行?
matrixWs
是对称片材。如何改进代码?
If activeRow >= 8 And activeRow < lastRow And deleteRowButton Then
Debug.Print Now & " start delete normal rows" --> 23:13:53
normalWs.Rows(activeRow).EntireRow.Delete
Debug.Print Now & " lap time before matrix" --> 23:13:53
matrixWs.Rows(activeRow).EntireRow.Delete
Debug.Print Now & " lap time after matrix row" --> 23:13:53
matrixWs.Columns(activeRow - 5).EntireColumn.Delete
Debug.Print Now & " lap time after matrix column" --> 23:13:56
End If
None
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)