![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
VBA
高枫-henu
这个作者很懒,什么都没留下…
展开
-
VBA 删除有颜色的行
[code="java"]Dim lecNum As Integer Dim lecturelastRow As Integer lecturelastRow = ActiveWorkbook.Sheets("sheeet1").UsedRange.Rows.Count For lecNum = 0 To lecturelastRow '将第...原创 2016-11-29 09:33:56 · 1576 阅读 · 0 评论 -
VBA 在指定目录及其子目录中的excel文件中检索指定的文字列
效果图:[img]http://dl2.iteye.com/upload/attachment/0121/5397/182b84b1-4557-3a19-8623-8f6a7eb3d5d9.png[/img]对应的代码入下:[code="vba"]对应的代码入下:Sub getColumn() Dim work1 As Workbook Di...原创 2016-11-29 09:34:12 · 1120 阅读 · 0 评论 -
VBA 禁止在某个sheet中使用键盘Delete键
1.按Alt+F11打开VBA编辑窗口2.双击要禁止delete的sheet,例如sheet13.在右边的编辑区的最上面加入下面的函数声明[code="java"]Private Declare Function GetKeyboardState Lib "user32" (pbKeyState As Byte) As Long[/code]对该sheet追加change事...原创 2016-11-29 09:34:26 · 1178 阅读 · 0 评论