
vba
槛外之人
这个作者很懒,什么都没留下…
展开
-
合并多sheet 带sheet名
Sub test() ActiveSheet.UsedRange.ClearContents Dim countalla, countthis As Integer countallb = 0 countthis = 0 For i = 1 To Sheets.Count If Sheets(i).Name <> ActiveSheet.Na原创 2016-06-15 14:28:59 · 1660 阅读 · 0 评论 -
vba 数据处理
Sub main() Dim n, i As Long n = 50 For i = 1 To n u (i) Next End Sub Sub u(i) Dim pos As Long Dim str1, str2 As String 'ActiveSheet.Cells(i, 3) = ActiveSheet.Cells(i, 2) pos = InStr(Sheet1.Cell原创 2016-08-25 15:07:38 · 1374 阅读 · 0 评论