![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
OFFICE
zoudaokou2006
宁静以致远,淡泊以明志
展开
-
请教关于用vba写undo的方法(Undoing a VBA Subroutine)
http://www.officefans.net/cdb/viewthread.php?tid=12129&fpage=1&highlight=undohttp://www.j-walk.com/ss/excel/tips/tip23.htmUndoing a VBA SubroutineComputer users have become accustomed to the abi转载 2009-02-15 03:01:00 · 2935 阅读 · 0 评论 -
EXCLE的两个简单宏脚本
最近修改EXCLE,尝试着学习了一下VBA,做一个记录 1.U列 值为I的全部删除 Sub Macro1()Dim i As IntegerDim max As Integermax = Worksheets("Sheet1").UsedRange.Rows.CountFor i = 2 To max If Cells(i, "U").Value = "I" Then原创 2009-02-16 23:07:00 · 950 阅读 · 0 评论